Ukončeno

Help with Business Finance

Tento projekt byl udělen uživateli haibg2111 za RM146 MYR.

Získat nabídky zdarma pro podobný projekt
Pracující zaměstnavatel
Rozpočet projektu
RM32 - RM99 MYR
Nabídky celkem
9
Popis projektu

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.

Uděleno uživateli:

Máte zájem si vydělat?

  • Zadejte váš rozpočet a dobu trvání práce
  • Ve zkratce popište svůj návrh
  • Dostaňte za svou práci zaplaceno

Zaměstnejte freelancery, kteří na tento projekt zveřejnili nabídku

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online