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.

Skills: Accounting, Business Analysis, Business Plans, Finance

See more: 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

About the Employer:
( 2 reviews ) Cyberjaya, Malaysia

Project ID: #12204506

Awarded to:


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 More

RM146 MYR in 1 day
(10 Reviews)

9 freelancers are bidding on average RM399 for this job


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 More

RM773 MYR in 1 day
(542 Reviews)

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 in 1 day
(99 Reviews)

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 More

RM311 MYR in 1 day
(61 Reviews)
RM200 MYR in 1 day
(76 Reviews)

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 in 2 days
(24 Reviews)

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 More

RM200 MYR in 1 day
(21 Reviews)
RM99 MYR in 1 day
(17 Reviews)

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 More

RM1000 MYR in 1 day
(8 Reviews)