A report on the company “PUMA” 1.) A financial statement review. 2.) Pro Forma f
ID: 2655668 • Letter: A
Question
A report on the company “PUMA”
1.) A financial statement review.
2.) Pro Forma financial statements (Balance Sheet and Income Statement) for the next two fiscal years, assuming a 10% growth rate in sales and Cost of Goods Sold (COGS) for each of the next two years.
3) A ratio analysis for the last fiscal year using at least two ratios from each of the following categories:
a. Liquidity
b. Financial leverage
c. Asset management
d. Profitability
e. Market value
4) Calculate Return on Equity (ROE) using the DuPont system
Please ONLY use own words, no plagerism.
Explanation / Answer
Note: Data for the last fiscal year is not available in the link provided .
Ans 2
Performa Financials (Income statement and Balance sheet)
Income Statement Q1 15 For the Whole year 2016 2017 *12 Sales 8,214.00 98,568.00 1,08,424.80 1,19,267.28 Cost of Goods Sold -4,365.00 -52,380.00 -57,618.00 -63,379.80 Gross Profit 3,849.00 46,188.00 50,806.80 55,887.48 Royalty & commission income Assumed to be 10% growth 37.00 444.00 488.40 537.24 Other Operating income & Expense Assumd to be fixed, except for 5% inflation growth -3,511.00 -42,132.00 -44,238.60 -46,450.53 EBIT 375.00 4,500.00 7,056.60 9,974.19 Income from Associated company Assumed to be 10% growth 9.00 108.00 118.80 130.68 EBT 384.00 4,608.00 7,175.40 10,104.87 Taxes on Income -108.00 -1,296.00 -2,018.08 -2,841.99 Net earnings to Non-controlling interest -28.00 -336.00 -523.21 -736.81 Net Earnings 248.00 2,976.00 4,634.11 6,526.06 Balance Sheet Assets Q1 2015 rep as % sales 2016 2017 Sales 98,568.00 108424.8 119267.28 Cash and Cash equivalents 2,950.00 3.0% 3,245.00 3,569.50 Inventories 6,480.00 6.6% 7,128.00 7,840.80 Trade Recievables 5,964.00 6.1% 6,560.40 7,216.44 Other Current assets( Working capital) 2,003.00 2.0% 2,203.30 2,423.63 Other Current assets 1,045.00 1.1% 1,149.50 1,264.45 Current Assets 18,442.00 18.7% 20,286.20 22,314.82 Deferred tax Assets 1,954.00 2.0% 2,149.40 2,364.34 Other Non-current assets 7,340.00 7.4% 8,074.00 8,881.40 Non-Current assets 9,294.00 9.4% 10,223.40 11,245.74 Total Assets 27,736.00 28.1% 30,509.60 33,560.56 Liabilities and Equity Current financial Liabilities 599.00 0.6% 658.90 724.79 Trade Payable 4,667.00 4.7% 5,133.70 5,647.07 Other current liabilities(Working capital related) 2,332.00 2.4% 2,565.20 2,821.72 Other current liabilities 1,516.00 1.5% 1,667.60 1,834.36 Current Liabilities 9,114.00 9.2% 10,025.40 11,027.94 Deferred Taxes 698.00 0.7% 767.80 844.58 Pension provisions 270.00 0.3% 297.00 326.70 Other Non -current liabilities 281.00 0.3% 309.10 340.01 Non-Current Liabilities 1,249.00 1.3% 1,373.90 1,511.29 Shareholder equity 17,373.00 17.6% 19,110.30 21,021.33 Total 27,736.00 28.1% 30,509.60 33,560.56Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.