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.

Dovednosti: Účetnictví, Obchodní analýza, Podnikatelské plány, Finance

Zobrazit více: 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

O zaměstnavateli:
( 2 recenzí ) Cyberjaya, Malaysia

IČ projektu: #12204506

Uděleno uživateli:


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 Více

RM146 MYR za 1 den
(10 recenzí)

9 freelanceů na tento projekt zveřejnilo nabídku v průměrné hodnotě RM399


Greetings! Ranked the #1 business plan writer on [url removed, login to view] 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 Více

RM773 MYR za 1 den
(542 recenzí)

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 za 1 den
(99 recenzí)

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 Více

RM311 MYR za 1 den
(61 recenzí)
RM200 MYR za 1 den
(76 recenzí)

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 za 2 dní
(24 recenzí)

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 Více

RM200 MYR za 1 den
(21 recenzí)
RM99 MYR za 1 den
(17 recenzí)

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 Více

RM1000 MYR za 1 den
(8 recenzí)