Financial forecast.docx

Financial forecast.docx - Income Statement Particulars Year...

Info icon This preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Income Statement Particulars Year 1 Year 2 Year 3 Inflation Rate 2.50% 2.50% Sales Growth Rate 6% 6% Sales Volume 350000 371000 393260 Selling Price Per Unit $4,750 $4,869 $4,990 Total Sales Revenue $1,662,500,00 0 $1,806,306,25 0 $1,962,551,74 1 Cost of Good Sold per unit: Raw Material Consumed ($1,500) ($1,538) ($1,576) Direct Labor Cost ($1,000) ($1,025) ($1,051) Total Cost of Goods Sold p.u. ($2,500) ($2,563) ($2,627) Total Cost of Goods Sold ($875,000,000 ) ($950,687,500 ) ############ # GROSS PROFIT $787,500,000 $855,618,750 $929,629,772 Variable Manufacturing Overhead p.u ($650) ($666) ($683) Total Variable Manufacturing Overhead ($227,500,000 ) ($247,178,750 ) ($268,559,712) Depreciation on Property,Plant & Equipment ($2,100,000) ($2,100,000) ($2,100,000) Total Manufacturing Overhead ($229,600,000 ) ($249,278,750 ) ($270,659,712) General Administrative Expenses: Depreciation on Furniture & Fixtures ($100,000) ($90,000) ($81,000) Depreciation on Computer Equipment ($180,000) ($158,400) ($139,392) Amortization of Patent ($100,000) ($100,000) ($100,000) Amortization of Trademark ($138,000) ($138,000) ($138,000) Insurance ($12,000) ($12,300) ($12,608) Rates & Taxes ($6,500) ($6,663) ($6,829) Salary of Office Staffs ($100,000) ($102,500) ($105,063)
Image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Cleaning Charges ($5,000) ($5,125) ($5,253) Electricity for Office ($15,000) ($15,375) ($15,759) Telephone & Internet ($8,000) ($8,200) ($8,405) Total General Administrative Expenses ($664,500) ($636,563) ($612,309) Selling & Marketing Expenses: Depreciation on Motor Vehicle ($180,000) ($158,400) ($139,392) Salary of Marketing Staffs ($150,000) ($153,750) ($157,594) Sales Commissions @0.5% on Sales ($8,312,500) ($9,031,531) ($9,812,759) Travelling charges @0.25% on Sales
Image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern