In Corso

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

Objective:

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.

Competenze: Contabilità, Analisi Aziendale, Piani Aziendali, Finanza

Mostra altro: 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

Sul datore di lavoro:
( 2 valutazioni ) Cyberjaya, Malaysia

ID Progetto: #12204506

Assegnato a:

haibg2111

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 Altro

RM146 MYR in 1 giorno
(10 valutazioni)
4.3

9 freelance hanno fatto un'offerta media di RM399 per questo lavoro

gregorybair

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 Altro

RM773 MYR in 1 giorno
(542 valutazioni)
9.2
salikgondal

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 giorno
(99 valutazioni)
6.1
rakeshwadhwani

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 Altro

RM311 MYR in 1 giorno
(61 valutazioni)
5.9
RM200 MYR in 1 giorno
(76 valutazioni)
5.6
RRconsultant

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 giorni
(24 valutazioni)
5.4
Tanmoy236

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 Altro

RM200 MYR in 1 giorno
(21 valutazioni)
4.2
RM99 MYR in 1 giorno
(17 valutazioni)
4.4
arslanu2

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 Altro

RM1000 MYR in 1 giorno
(8 valutazioni)
3.1