an examaple is as attached on the appindix 1&2.. please i need it ASAB Appendix
ID: 2654752 • Letter: A
Question
an examaple is as attached on the appindix 1&2.. please i need it ASAB
Appendix 2: Historical & Pro-Forma Balance Sheet USD in Millions Assets Current Assets Dec. 31, 2012 2013E 2014F 2015F 2016F 2017F 2018F Cash & Equivalents Accounts Receivable, net Prepaid Expenses Other Current Assets Income Taxes Receivable Defrred Tax Asset Total Current Assets $108.34 S9.73 $7.23 $5.92 S93.43$103.38S104.89$105.72$107.65 $108.94 $9.78 $7.27 $9.28 $6.90 $5.65 $9.42 S7.00 S5.73 $9.67 $7.18 $7.05 S5.78 S6.23 $7.62 $8.78 $141.81$122.30 $135.32 $137.29$138.38$140.91$142.59 Property and Equipment $40.68 $40.68 $40.68 $40.68 Leasehold Improvements Computer Equipment & Software Furniture & Office Equip Capital Projects in Process Total PPE Less Accumulated Depreciation Net PPE $40.68 $40.68 $40.68 $267.90 $283.71$317.10 $354.04$391.52$429.30$467.77 $26.33 $17.18 S343.93S365.44 $400.40 $437.58$475.19 $513.28$551.95 S(187.44) S(188.16) S(195.93) $(201.52) $(207.18) $(212.91) $(218.73) $156.49$177.29$204.47$236.06$268.01$300.37$333.22 $26.33 $14.73 $26.33 $26.33 $16.67 $26.33 $16.97 $23.55 $26.33 $16.54 $21.04 $90.23 $21.04 $90.23 $21.04 $90.23 Other Assets Net Intangibles Long Term Deferred Tax Asset Net Goodwill Net Customer Contracts $21.04 $90.23 $90.23 $90.23 $90.23 S338.70S338.70$338.70 $338.70$338.70 $338.70$338.70 S- S- S- S- S- S- S- Total Assets $748.27$749.55$789.75$823.32$856.36$891.24$925.78 Source: Company Financials & Team Estimates Assumptions: Current Assets: Expected to remain at a constant percentage of sales Leasehold Improvements:Held constant over the forecast period omputer Equipment: Furniture & Office Equip Capital Projects in Progress: Expected to increase by 5% of sales from year to year Held constant over the forecast period Expected to remain at a constant percentage of sales ice Equip. Held consExplanation / Answer
Increase in Computer Equipment 2016 = 391.52 – 354.04 = 37.48
5% sales of 2016 = 37.48
Sales of 2016 = 37.48 x 100 / 5 = 749.6
Increase in Computer Equipment 2017 = 429.30 – 391.52 = 37.78
5% sales of 2017 = 37.78
Sales of 2017 = 37.78 x 100 / 5 = 755.6
Increase in Computer Equipment 2018 = 467.77 – 429.30 = 38.47
5% sales of 2018 = 38.47
Sales of 2018 = 38.47 x 100 / 5 = 769.40
Proforma statement 2016 2017 2018 Net Sales 749.6 755.6 769.4 Total operating costs and expenses 742.4038 760.2092 786.1729 Operating Income 7.19616 -4.60916 -16.7729 Total Non-operating expenses 2.884221 -2.51476 -11.58 Income before tax 4.311939 -7.12392 -28.3529Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.