Lezárt

Help with Business Finance

A projektet haibg2111 felhasználó nyerte el az alábbi feltételekkel: RM146 MYR.

Kapjon ingyenes árajánlatokat egy hasonló projektre
A munkaadó dolgozik
Projekt költségvetés
RM32 - RM99 MYR
Összes Árajánlat
9
Projekleírás

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.

Odaítélve:

Szeretne pénzt keresni?

  • Adja meg a költségvetést és a munkaelvégzéséhez szükséges időt
  • Vázolja fel ajánlatát
  • Kapjon fizetést munkájáért

Alkalmazza a szabadúszókat, akik erre a projektre is ajánlatot adtak

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