Help with Business Finance

I am starting up a business based on installment sales for my products. Product prices range between $500 to $1500 . I require a spreadsheet that will show the profit/loss and revenue projections for the next 6 years based on these data:

Starting Capital : MYR 1,000,000

Target average customers : 15/mnth for the first 2 years, 30/mnth for the next 2 and 60/mnth for the final 2 years

Avg Cost per customer : MYR 3,000

Fee/Profit taken per sales : 25% (RM 750)

Avg Sales price per customer : MYR 3,750 (cost + fee)

Upfront payment for each sales : 30% (RM1,125)

Period of installments : 3 Years

Operational Costs : MYR 8000/mnth for the first 2 years, MYR 20,000/mnth for the next 2 years and MYR 50,000/mnth for the final 2 years

Other Income : MYR 10,000/mnth for the first 2 years, MYR 35,000/mnth for the next 2 and MYR 40,000/mnth for the final 2 years

Taxation :

Corporate Tax : Exempt for the first 5 years (for as long as revenue is below MYR [url removed, login to view] per annum)

Sales Tax : 5% (inlcusive in sales price, borne by company)

Non-Payments (non-recoverable)

Default Payments : 2% of customers per annum


1) Projection of Company's Revenue , P/L

2) Application of Installment Sales Accounting formula

3) Projection of Account Balance

This is a simple spreadsheet project with given set of data.

Készségek: Számvitel, Üzleti elemzés, Üzleti tervek, Pénzügy

Bővebben: business help needed, islamic finance business plan, business help, need finance business, finance business cards pics, writing english finance business, finance business card examples, finance business cards, can quantitative reasoning business help, finance business research consulting services, finance business administration public schools phillippines, owner finance business contract, need finance loan help, needed finance loan help, owner finance business contracts

A munkaadóról:
( 2 értékelés ) Cyberjaya, Malaysia

Projektazonosító: #12204506



Dear the client, Owh, i hope that my message sifts through spam and reaches you well. DO YOU WANT TO DO PROJECTIONS ONE TIME OR YOU WANT TO A TEMPLATE THAT YOU CAN REUSE? if you create a template, any indicators cha Több

RM146 MYR 1 napon belül
(10 értékelés)

9 szabadúszó tett átlagosan RM399 árajánlatot erre a munkára


Greetings! Ranked the #1 business plan writer on since 2010, I thank you for the opportunity to work on this important project. I have created more than 800 business plans, financial and marketing Több

RM773 MYR 1 napon belül
(542 vélemény)

I am expert in handling similar tasks because I have a professional degree in accounts and finance. Let me assist you in this.

RM311 MYR 1 napon belül
(99 vélemény)

Dear Valued Employer, I can add value to your project, by suggesting new ideas. I am fast and reliable. For further understanding why I am the right firm for your project, kindly check my profile, reviews, rating and Több

RM311 MYR 1 napon belül
(61 vélemény)
RM200 MYR 1 napon belül
(76 vélemény)

Hi there, I am a specialist in finance and financial modeling and can help you with the task. Look forward to hear from you. Thanks, RRC

RM555 MYR 2 napon belül
(24 vélemény)

I am a Business (BBA) Graduate with major in FINANCE and MARKETING along with 4 years of experience in Sales, Marketing and Copy writing. Currently I am working for a Multinational Telecommunication Company in the Mark Több

RM200 MYR 1 napon belül
(21 vélemény)
RM99 MYR 1 napon belül
(17 vélemény)

I am a person of chartered accountancy background and I can complete all kinds of accounting, business planning, Business proposals, business analysis, academic, content writing, management, consultancy, report writing Több

RM1000 MYR 1 napon belül
(8 vélemény)