a. Income Statement for the FY 2020
Particulars | Calculation | Amount |
Sales | 4% (115,450+4%) | 120,068 |
COGS | (42,500/115,450)*120,068 | 44,425.16 |
SGA | (38,000/115,450)*120,068 | 39,622.44 |
Depreciation | (15,000/115,450)*120,068 | 15,608.84 |
EBIT | 20,411.56 | |
Interest expense | (3,550/115,450)*120,068 | 3,602.04 |
EBT | 16,809.52 | |
Taxes | (3444/16,400)*16,809.52 | 3,530 |
Net Income | 13,279.52 | |
Dividends | (6000/12956)*13279.52 | 6,108.58 |
Addition to Retained Earnings | 7,170.94 |
Balance Sheet
Particulars | Calculation | Amount |
Cash | (147,145/115,450)*120,068 | 152,486.36 |
Acct. Receivable | (29,129/115,450)*120,068 | 30,017 |
Inventory | (2,928/115,450)*120,068 | 3,602.04 |
Other Current Assets | (7,409/115,450)*120,068 | 7,204.08 |
Net Fixed Assets | (103,910/115,450)*120,068 | 108,061.20 |
Total Assets | 301,370.68 | |
Accts. Payable | (9,479/42,500)*44,425.16 | 9,773.54 |
Long term Debt | Bal.Figure | 187,630.20 |
Common Stock | 78,345 | |
Retained Earnings | 18,451+ 7,170.94 | 25.621.94 |
Total Lia. & Equity | 301,370.68 |
External Financing Needed for the firm = 187,630.20 - 184,246 = 3,384.20
Given the most recent financial statements for Microsoft (FY2019). Sales for FY2020 are expected to grow...
Given the most recent financial statements for Microsoft (FY2019). Sales for FY2020 are expected to grow by 4 percent. The following assumption must hold in the pro forma financial statements. The tax rate (percentage) and the dividend payout ratio (percentage) will remain constant. COGS, SGA, Depreciation, Interest Expense, Cash, Account Receivable, Inventory, Other Current Assets, and Net Fixed Asset increase spontaneously with sales. If the firm is operating at full capacity and no new debt or equity are issued, calculate...
Given the most recent financial statements for Microsoft (FY2019). Sales for FY2020 are expected to grow by 4 percent. The following assumption must hold in the pro forma financial statements. The tax rate (percentage) and the dividend payout ratio (percentage) will remain constant. COGS, SGA, Depreciation, Interest Expense, Cash, Account Receivable, Inventory, Other Current Assets, and Net Fixed Asset increase spontaneously with sales. If the firm is operating at full capacity and no new debt or equity are issued, calculate...
Question 6 4 points Save Answer Given the following financial statement information for Microsoft. Calculate the debt-to-equity ratio for FY2019. (Enter in decimal form and round to 4 decimals) Balance Sheet Simplified Statements for MSFT Income Statement FY2019 Cash FY2019 147,145 29,129 2,928 Sales COGS 115,450 42,500 38,000 Acct. Receivable Inventory Other Current Assets Net Fixed Assets SGA 7,409 Depreciation 15,000 103,910 EBIT 19,950 Total Assets 290,521 Interest Expense 3,550 16,400 EBT 9,479 Taxes 3444 Net Income Acct. Payable Long...
The most recent financial statements for Fleury Inc., follow Sales for 2015 are projected to grow by 25 percent. Interest expense will remain constant, the tax rate and the dividend payout rate will also remain constant. Costs, other expenses, current assets, fixed assets and accounts payable increase spontaneously with sales FLEURY, INC 2014 Income Statement Sales Costs Other expenses $754,000 589,000 10,000 Eamings before interest and taxes $155,000 11,000 Interest paid Taxable income $144,000 43,200 Taxes (30%) Net income Dividends...
The most recent financial statements for Fleury Inc., follow. Sales for 2012 are projected to grow by 20 percent. Interest expense will remain constant, the tax rate and the dividend payout rate will also remain constant. Costs, other expenses, current assets, fixed assets and accounts payable increase spontaneously with sales FLEURY, INC 2011 Income Statement Sales Costs Other expenses $ 758,000 593,000 14,000 Earnings before interest and taxes Interest paid $151,000 10,000 Taxable income Taxes (40%) $141,000 56,400 Net income...
The most recent financial statements for Fleury Inc., follow. Sales for 2012 are projected to grow by 20 percent. Interest expense will remain constant, the tax rate and the dividend payout rate will also remain constant. Costs, other expenses, current assets, fixed assets and accounts payable increase spontaneously with sales FLEURY, INC 2011 Income Statement Sales Costs Other expenses $ 758,000 593,000 14,000 Earnings before interest and taxes Interest paid $151,000 10,000 Taxable income Taxes (40%) $141,000 56,400 Net income...
The most recent financial statements for Fleury Inc., follow. Sales for 2012 are projected to grow by 20 percent. Interest expense will remain constant, the tax rate and the dividend payout rate will also remain constant. Costs, other expenses, current assets, fixed assets and accounts payable increase spontaneously with sales FLEURY, INC 2011 Income Statement Sales Costs Other expenses $ 758,000 593,000 14,000 Earnings before interest and taxes Interest paid $151,000 10,000 Taxable income Taxes (40%) $141,000 56,400 Net income...
The most recent financial statements for Fleury Inc., follow. Sales for 2015 are projected to grow by 25 percent. Interest expense will remain constant; the tax rate and the dividend payout rate will also remain constant. Costs, other expenses, current assets, fixed assets and accounts payable increase spontaneously with sales. FLEURY, INC. 2014 Income Statement Sales $ 757,000 Costs 592,000 Other expenses 13,000 Earnings before interest and taxes $ 152,000 Interest paid 15,000 Taxable income $ 137,000 Taxes (20%) 27,400...
The most recent financial statements for Crosby, Inc., follow. Sales for 2018 are projected to grow by 25 percent. Interest expense will remain constant; the tax rate and the dividend payout rate will also remain constant. Costs, other expenses, current assets, fixed assets, and accounts payable increase spontaneously with sales. CROSBY, INC. 2017 Income Statement Sales Costs Other expenses $748.000 583,000 19,000 Earnings before interest and taxes Interest paid $ 146,000 15,000 Taxable income Taxes (25%) $ 131,000 32.750 Net...
The most recent financial statements for Crosby, Inc., follow. Sales for 2018 are projected to grow by 30 percent. Interest expense will remain constant; the tax rate and the dividend payout rate will also remain constant. Costs, other expenses, current assets, fixed assets, and accounts payable increase spontaneously with sales. CROSBY, INC. 2017 Income Statement Sales $ 749,000 Costs 584,000 Other expenses 20,000 Earnings before interest and taxes $ 145,000 Interest paid 16,000 Taxable income $ 129,000 Taxes (21%) 27,090...