Financial information on AAA Ltd. is shown below. AAA Ltd. Income Statement For the Year Ended...

 

 

Transcribed Image Text:

Financial information on AAA Ltd. is shown below. AAA Ltd. Income Statement For the Year Ended December 31st, 2019 2018 5,375,25 4,025,35 0 0 2,835,45 2,105,83 0 7 1,100,50 1,058,60 0 0 75,500 67,800 1,363,80 793,113 68,925 724,188 217,256 $ 506,932 Sales Cost Of Goods Sold Other Expenses Depreciation Earnings Before Interest and Taxes Interest Expense Earnings Before Taxes Taxes (30%) Net Income ASSETS Cash & Equivalent Short-term investments Inventories Accounts Receivable Total Current Assets Prop, Plant & Equip - Net Total Assets AAA Ltd. Balance Sheet As at December 31st, LIABILITIES & EQUITY Accounts Payable Notes Payable Accruals Short-term Debt Total Current Liabilities Long-Term Debt Ryerson Page 2 of 7 AFF 210 Total Liabilities Common Share Capital Retained Earnings 0 84,350 1,279,45 0 383,835 $ 895,615 Total Equity Total Liabilities and Equity 2019 2018 67,250 53,925 225,783 192,243 1,522,500 1,407,530 303,200 221,058 2,118,733 1,874,756 2,582,989 2,002,958 $ $ 4,701,672 3,877,714 392,952 101,982 76,205 325,029 896,168 1,054,024 275,929 89,203 57,292 1,950,192 650,000 2,101,480 2,751,480 $ 4,701,672 317,416 739,840 873,204 ASSIGNMENT TWO 1,613,044 650,000 1,614,670 2,264,670 $ 3,877,714 WINTER 2020 Answer the following questions. Please note: short-term investments are non-operating current assets; notes payable and short-term debt are non-operating current liabilities. a) What is Operating Cash Flow for 2019? b) What is Free Cash Flow for 2019? c) The stock is traded at $40 per share at the end of 2019 and there are 100,000 shares outstanding. What is MVA during 2019? d) Given the firm's WACC is 10%, what is EVA during 2019? e) Create common size income statement and balance sheet for both 2019 and 2018. f) Create income statement and balance sheet percentage change analysis for 2019. (Use 2018 as the base year) In addition to the AAA Ltd. financial statements in Problem One, you are given more information as follows. Sales are forecast to increase by 20% in 2020. Notes Payable, Short-term Debt, Long-term Debt, and Common Share Capital will not change. Net Plant and Equipment is forecasted to be $2,900,000 next year. Short-term investments are expected to be $240,000. In 2020, the company's dividend payout ratio will be 40%. In 2020, cost of goods sold is expected to be 52% of sales. Other expenses will be 23% of sales. Depreciation expense in 2020 is expected to be $90,000. Cash is expected to be 2% of sales, and inventories will be 30% of sales. Accounts receivable will be 6% of sales. Accounts payable will be 5% of sales. Accruals will be 1% of sales. The company is expected to pay 4% per year compounded annually on its short-term debt and 6% per year compounded annually on its long-term debt. The interest expense on the short-term debt in 2020 is calculated as: [interest rate on short-term debt* amount of short-term debt outstanding at the end of 2019]. The interest expense on the long-term debt is calculated as: [interest rate on long-term debt * amount of long-term debt outstanding at the end of 2019]. The company's tax rate is 30%. Based on the information provided you are to: a) Complete the pro-forma income statement and balance sheet for 2020. b) Calculate the amount of Additional Funds Needed in 2020. Financial information on AAA Ltd. is shown below. AAA Ltd. Income Statement For the Year Ended December 31st, 2019 2018 5,375,25 4,025,35 0 0 2,835,45 2,105,83 0 7 1,100,50 1,058,60 0 0 75,500 67,800 1,363,80 793,113 68,925 724,188 217,256 $ 506,932 Sales Cost Of Goods Sold Other Expenses Depreciation Earnings Before Interest and Taxes Interest Expense Earnings Before Taxes Taxes (30%) Net Income ASSETS Cash & Equivalent Short-term investments Inventories Accounts Receivable Total Current Assets Prop, Plant & Equip - Net Total Assets AAA Ltd. Balance Sheet As at December 31st, LIABILITIES & EQUITY Accounts Payable Notes Payable Accruals Short-term Debt Total Current Liabilities Long-Term Debt Ryerson Page 2 of 7 AFF 210 Total Liabilities Common Share Capital Retained Earnings 0 84,350 1,279,45 0 383,835 $ 895,615 Total Equity Total Liabilities and Equity 2019 2018 67,250 53,925 225,783 192,243 1,522,500 1,407,530 303,200 221,058 2,118,733 1,874,756 2,582,989 2,002,958 $ $ 4,701,672 3,877,714 392,952 101,982 76,205 325,029 896,168 1,054,024 275,929 89,203 57,292 1,950,192 650,000 2,101,480 2,751,480 $ 4,701,672 317,416 739,840 873,204 ASSIGNMENT TWO 1,613,044 650,000 1,614,670 2,264,670 $ 3,877,714 WINTER 2020 Answer the following questions. Please note: short-term investments are non-operating current assets; notes payable and short-term debt are non-operating current liabilities. a) What is Operating Cash Flow for 2019? b) What is Free Cash Flow for 2019? c) The stock is traded at $40 per share at the end of 2019 and there are 100,000 shares outstanding. What is MVA during 2019? d) Given the firm's WACC is 10%, what is EVA during 2019? e) Create common size income statement and balance sheet for both 2019 and 2018. f) Create income statement and balance sheet percentage change analysis for 2019. (Use 2018 as the base year) In addition to the AAA Ltd. financial statements in Problem One, you are given more information as follows. Sales are forecast to increase by 20% in 2020. Notes Payable, Short-term Debt, Long-term Debt, and Common Share Capital will not change. Net Plant and Equipment is forecasted to be $2,900,000 next year. Short-term investments are expected to be $240,000. In 2020, the company's dividend payout ratio will be 40%. In 2020, cost of goods sold is expected to be 52% of sales. Other expenses will be 23% of sales. Depreciation expense in 2020 is expected to be $90,000. Cash is expected to be 2% of sales, and inventories will be 30% of sales. Accounts receivable will be 6% of sales. Accounts payable will be 5% of sales. Accruals will be 1% of sales. The company is expected to pay 4% per year compounded annually on its short-term debt and 6% per year compounded annually on its long-term debt. The interest expense on the short-term debt in 2020 is calculated as: [interest rate on short-term debt* amount of short-term debt outstanding at the end of 2019]. The interest expense on the long-term debt is calculated as: [interest rate on long-term debt * amount of long-term debt outstanding at the end of 2019]. The company's tax rate is 30%. Based on the information provided you are to: a) Complete the pro-forma income statement and balance sheet for 2020. b) Calculate the amount of Additional Funds Needed in 2020.

Answer rating: 100% (QA)

Profarma Income Statement of AAA Ltdk Sales Costof goods Sold Other Expenses Depreciation Earnings ... View the full answer