90.2K

Verified Solution

Link Copied!

ENTER DATA ONLY FOR PRO FORM WITHOUT CORRECTIONS

INCOME STATEMENT	FORECAST FOR 2020
Total Sales	$
Cost of Goods Sold	$
Administrative expenses	$
Depreciation	$
Taxes	$
Dividends	$

BALANCE SHEET	FORECAST FOR 2020
Cash	$
Accounts Receivable	$
Inventory	$
Net Fixed Assets	$
Accounts payable	$
Retained earnings	$
TOTAL LIABILITIES & STOCKHOLDER'S EQUITY	$
EXTERNAL FUNDS NEEDED (EFN) (Must include the minus sign if EFN is a negative value for it to be counted correct.)	$

Do not include the dollar sign ($) or percent sign (%) in your answer.
Profit Margin Round to 2 decimal places (e.g., 12.34)	%
Return on Assets (ROA) Round to 2 decimal places (e.g., 12.34)	%
Return on Equity (ROE) Round to 2 decimal places (e.g., 12.34)	%
Earnings Per Share (EPS) Round to 2 decimal places (e.g., 12.34)	$
End of year stock price Round to 2 decimal places (e.g., 12.34)	$
Net Working Capital (NWC) Round to the nearest whole dollar (e.g., 1,234)	$

CASE STUDY AutoSave Of 9 Formulas Data Review Vi File Home Insert Page Layout Draw General ab Arial - 11 AA === Paste $ %, BIU A Number Alignment Font Clipboard fo E8 D C E F A B ASSUMPTIONS FROM 2019 5 5.45% 6 Depreciation as a % of nel fixed assets 33.00% Income tax rate 7 Dividend payout ratio 25.00% Fixed assets as a percent of total capacity 88.504 9 D PRO FORMA WITHOUT CORRECTIONS PRO FORMA WITH CORRECTIONS EFFECT OF MAKING CORRECTIONS 11 FORECAST FOR FORECAST FOR 2020 2020 T Actual Change % Change + Global Manufacturing, Inc 2019 Sustainable Growth Rate- (from GROWTH RATE worksheer part 0.00% 0.00% T3 Values transfer from the previous workshe INCOME STATEMENTS $71,900,600 $57,209,900 50 57.485400 50 $7 205,300 $0 $0 50 $0 SO 50 SEF 0.0% SEE 0.0N SEE 50 $0 0.0% Te Total sales estimate Cost of goods sold Administrative expense Earnings before interest, taxes, 10 depreciation & amortization (EBITDA Depreciation we 20 Earrings before interest taxes. IEHTI 21 - Interest expense Earrings Before Taxus (EBTI 23 Tax Net income SEE 50 $0 SO 1.256.600 $1,256,600 0.0% 1.46.3400 $5,741,900 1.250.00 $4485,300 1.480, 100 53,005,20 751,200 A be SO 1.256.6.00 $1 256,600 90 $1.256,600 50 $0 $0 50 so sol $1,256,600 $0 0.0% 0.0% 0.0% 0.0% ASI she Dividends ... PRO FORMAS 2020 REQUIRED CORRECTIONS WACC CAPITAL BUDGETING INS Ready EL Type here to search O w esc ? 15 @ $ % 2 3 4 5 6 BIU 3 Number Alignment Font Clipboard fx E8 F G $0 0.0% B 19 w Depreciation 20 00 Farming before interest & laxes.(EBIT) F interest expense 22 Earnings Before Taxes (EBT) 22 Taxes 24 Nelince 35 Dividends 26 Additions to Retained Earnings 20 28 $0 $0 1.256.600 $1,256,600 D 50 $0 1.256.600 $1,256,600 50 $1,256,600 so $1,256,600 1463.400 $5,741,900 1.256,600 54.485.300 1.480.000 $3,005,200 751,300 52,253,900 $1,256,600 $0 $1,256,600 sol $0 $0 $0 $0 0.0% 0.0% 0.0% 0.0% 0.0% BALANCE SHEETS 29 Values transfer from the previous workshe $0 $0 $0 +30 Sol $0 0.0%SEE 0.0% SEE 0,0% SEE 0.0% 0.0% SEE 0.0% SEEN ASSETS 20 $1,050,500 50 $0 21 Cash Accorreceivable 50 10,499 300 32 $0 33 $0 14.612.200 inventory 50 34 $0 26,162,600 Total Current Assets $0 25 Not Fixed Assets 29.111,000 50 TOTAL ASSETS $55.281,100 50 $0 LIABILITIES & STOCKHOLDER'S EQUITY 31 39 Accounts payable 5,844,700 SC $0 33 Nutes wat 8.497.400 58.497.400 $8.497.400 Total current liabilities 14,342.100 $8,497.400 $8.497.400 31 Long term dat 12032.900 $13,032.900 312.032.900 TUTAL LIABILITIES 27,375,000 $21,530,300 $21,530,300 Common stock 2,750,000 $2,750,000 $2,750,000 Pelandang 25,155,100 $0 TOTAL STOCKHOLDERS' EQUITY 27.986.100 $2.750.000 $2.750.000 TOTAL LORO. 4 ... PRO FORMAS 2020 REQUIRED CORRECTIONS WACC Ready A you 40 Comed Sustain $0 $0 0.0%SEEWS 0.0 CAPITAL BUDGETING INST Type here to search O W e esc ? a # 7 $ % 2 3 4 5 6 tab w E R Caps lock A S D F G z BIU Alignment Number 5 Clipboard 5 Font fx 08 Assume you can es F Noles payable $8.492.400 $8,497,400 513,032.900 $21,530,300 $2,750,000 1.497400 14,342,100 13,032.900 27,375,000 2.750,000 25.156, 1001 2.900,100 $55,281.100 $8.492.400 $8,497,400 $13.032.900 $21,530,300 $2,750,000 Sustainable Total current liabilities Long-term debt TOTAL LIABILITIES Common stock Retained earnings TOTAL STOCKHOLDERS' EQUITY TOTAL LIABILITIES & STOCKHOLDERS EDUTY sol 0.0% SEE INSTRUC 52.750.000 $2.750.000 $0 0.0% $24,280,300 $24,280,300 50 0.0% External Funds Needed = $0 $0 sol 0.0% SEE INSTRUG 2,750,000 Common shares outstanding Profit Marin * Return on Assets ROA Retura en quly (DE) rings Per Share ILPS) End-of your stock price Net Working Capital (WC) IMPORTANT PERFORMANCE MEASURES 2,750,000 2,750,000 0.00% 6.44% 0.00 0.00% - 10.17 0.00% 0.00% - $1.09 50.00 $0.00 $27.75 50.00 50.00 $11,620,500 1 0.0% 02% 0.0% $0.00 $0.00 50 0.0% 0.0% 0.0% 0,0% 0.0% 0. Calculate the stated End of Year stock price by using the following formula End-of year stock price.. - P/E Ratio 1 * Earnings Per Share (EPS) ... PRO FORMAS 2020 REQUIRED CORRECTIONS WACC CAPITAL BUDGETING INSTRUCTIC Ready Type here to search O e @ *M # $ % 2 4 5 6 lab Q E R T lock A s D G H N VB BIU 3 Number Alignment Font Clipboard fx E8 F G $0 0.0% B 19 w Depreciation 20 00 Farming before interest & laxes.(EBIT) F interest expense 22 Earnings Before Taxes (EBT) 22 Taxes 24 Nelince 35 Dividends 26 Additions to Retained Earnings 20 28 $0 $0 1.256.600 $1,256,600 D 50 $0 1.256.600 $1,256,600 50 $1,256,600 so $1,256,600 1463.400 $5,741,900 1.256,600 54.485.300 1.480.000 $3,005,200 751,300 52,253,900 $1,256,600 $0 $1,256,600 sol $0 $0 $0 $0 0.0% 0.0% 0.0% 0.0% 0.0% BALANCE SHEETS 29 Values transfer from the previous workshe $0 $0 $0 +30 Sol $0 0.0%SEE 0.0% SEE 0,0% SEE 0.0% 0.0% SEE 0.0% SEEN ASSETS 20 $1,050,500 50 $0 21 Cash Accorreceivable 50 10,499 300 32 $0 33 $0 14.612.200 inventory 50 34 $0 26,162,600 Total Current Assets $0 25 Not Fixed Assets 29.111,000 50 TOTAL ASSETS $55.281,100 50 $0 LIABILITIES & STOCKHOLDER'S EQUITY 31 39 Accounts payable 5,844,700 SC $0 33 Nutes wat 8.497.400 58.497.400 $8.497.400 Total current liabilities 14,342.100 $8,497.400 $8.497.400 31 Long term dat 12032.900 $13,032.900 312.032.900 TUTAL LIABILITIES 27,375,000 $21,530,300 $21,530,300 Common stock 2,750,000 $2,750,000 $2,750,000 Pelandang 25,155,100 $0 TOTAL STOCKHOLDERS' EQUITY 27.986.100 $2.750.000 $2.750.000 TOTAL LORO. 4 ... PRO FORMAS 2020 REQUIRED CORRECTIONS WACC Ready A you 40 Comed Sustain $0 $0 0.0%SEEWS 0.0 CAPITAL BUDGETING INST Type here to search O W e esc ? a # 7 $ % 2 3 4 5 6 tab w E R Caps lock A S D F G z CASE STUDY AutoSave Of 9 Formulas Data Review Vi File Home Insert Page Layout Draw General ab Arial - 11 AA === Paste $ %, BIU A Number Alignment Font Clipboard fo E8 D C E F A B ASSUMPTIONS FROM 2019 5 5.45% 6 Depreciation as a % of nel fixed assets 33.00% Income tax rate 7 Dividend payout ratio 25.00% Fixed assets as a percent of total capacity 88.504 9 D PRO FORMA WITHOUT CORRECTIONS PRO FORMA WITH CORRECTIONS EFFECT OF MAKING CORRECTIONS 11 FORECAST FOR FORECAST FOR 2020 2020 T Actual Change % Change + Global Manufacturing, Inc 2019 Sustainable Growth Rate- (from GROWTH RATE worksheer part 0.00% 0.00% T3 Values transfer from the previous workshe INCOME STATEMENTS $71,900,600 $57,209,900 50 57.485400 50 $7 205,300 $0 $0 50 $0 SO 50 SEF 0.0% SEE 0.0N SEE 50 $0 0.0% Te Total sales estimate Cost of goods sold Administrative expense Earnings before interest, taxes, 10 depreciation & amortization (EBITDA Depreciation we 20 Earrings before interest taxes. IEHTI 21 - Interest expense Earrings Before Taxus (EBTI 23 Tax Net income SEE 50 $0 SO 1.256.600 $1,256,600 0.0% 1.46.3400 $5,741,900 1.250.00 $4485,300 1.480, 100 53,005,20 751,200 A be SO 1.256.6.00 $1 256,600 90 $1.256,600 50 $0 $0 50 so sol $1,256,600 $0 0.0% 0.0% 0.0% 0.0% ASI she Dividends ... PRO FORMAS 2020 REQUIRED CORRECTIONS WACC CAPITAL BUDGETING INS Ready EL Type here to search O w esc ? 15 @ $ % 2 3 4 5 6 BIU 3 Number Alignment Font Clipboard fx E8 F G $0 0.0% B 19 w Depreciation 20 00 Farming before interest & laxes.(EBIT) F interest expense 22 Earnings Before Taxes (EBT) 22 Taxes 24 Nelince 35 Dividends 26 Additions to Retained Earnings 20 28 $0 $0 1.256.600 $1,256,600 D 50 $0 1.256.600 $1,256,600 50 $1,256,600 so $1,256,600 1463.400 $5,741,900 1.256,600 54.485.300 1.480.000 $3,005,200 751,300 52,253,900 $1,256,600 $0 $1,256,600 sol $0 $0 $0 $0 0.0% 0.0% 0.0% 0.0% 0.0% BALANCE SHEETS 29 Values transfer from the previous workshe $0 $0 $0 +30 Sol $0 0.0%SEE 0.0% SEE 0,0% SEE 0.0% 0.0% SEE 0.0% SEEN ASSETS 20 $1,050,500 50 $0 21 Cash Accorreceivable 50 10,499 300 32 $0 33 $0 14.612.200 inventory 50 34 $0 26,162,600 Total Current Assets $0 25 Not Fixed Assets 29.111,000 50 TOTAL ASSETS $55.281,100 50 $0 LIABILITIES & STOCKHOLDER'S EQUITY 31 39 Accounts payable 5,844,700 SC $0 33 Nutes wat 8.497.400 58.497.400 $8.497.400 Total current liabilities 14,342.100 $8,497.400 $8.497.400 31 Long term dat 12032.900 $13,032.900 312.032.900 TUTAL LIABILITIES 27,375,000 $21,530,300 $21,530,300 Common stock 2,750,000 $2,750,000 $2,750,000 Pelandang 25,155,100 $0 TOTAL STOCKHOLDERS' EQUITY 27.986.100 $2.750.000 $2.750.000 TOTAL LORO. 4 ... PRO FORMAS 2020 REQUIRED CORRECTIONS WACC Ready A you 40 Comed Sustain $0 $0 0.0%SEEWS 0.0 CAPITAL BUDGETING INST Type here to search O W e esc ? a # 7 $ % 2 3 4 5 6 tab w E R Caps lock A S D F G z BIU Alignment Number 5 Clipboard 5 Font fx 08 Assume you can es F Noles payable $8.492.400 $8,497,400 513,032.900 $21,530,300 $2,750,000 1.497400 14,342,100 13,032.900 27,375,000 2.750,000 25.156, 1001 2.900,100 $55,281.100 $8.492.400 $8,497,400 $13.032.900 $21,530,300 $2,750,000 Sustainable Total current liabilities Long-term debt TOTAL LIABILITIES Common stock Retained earnings TOTAL STOCKHOLDERS' EQUITY TOTAL LIABILITIES & STOCKHOLDERS EDUTY sol 0.0% SEE INSTRUC 52.750.000 $2.750.000 $0 0.0% $24,280,300 $24,280,300 50 0.0% External Funds Needed = $0 $0 sol 0.0% SEE INSTRUG 2,750,000 Common shares outstanding Profit Marin * Return on Assets ROA Retura en quly (DE) rings Per Share ILPS) End-of your stock price Net Working Capital (WC) IMPORTANT PERFORMANCE MEASURES 2,750,000 2,750,000 0.00% 6.44% 0.00 0.00% - 10.17 0.00% 0.00% - $1.09 50.00 $0.00 $27.75 50.00 50.00 $11,620,500 1 0.0% 02% 0.0% $0.00 $0.00 50 0.0% 0.0% 0.0% 0,0% 0.0% 0. Calculate the stated End of Year stock price by using the following formula End-of year stock price.. - P/E Ratio 1 * Earnings Per Share (EPS) ... PRO FORMAS 2020 REQUIRED CORRECTIONS WACC CAPITAL BUDGETING INSTRUCTIC Ready Type here to search O e @ *M # $ % 2 4 5 6 lab Q E R T lock A s D G H N VB BIU 3 Number Alignment Font Clipboard fx E8 F G $0 0.0% B 19 w Depreciation 20 00 Farming before interest & laxes.(EBIT) F interest expense 22 Earnings Before Taxes (EBT) 22 Taxes 24 Nelince 35 Dividends 26 Additions to Retained Earnings 20 28 $0 $0 1.256.600 $1,256,600 D 50 $0 1.256.600 $1,256,600 50 $1,256,600 so $1,256,600 1463.400 $5,741,900 1.256,600 54.485.300 1.480.000 $3,005,200 751,300 52,253,900 $1,256,600 $0 $1,256,600 sol $0 $0 $0 $0 0.0% 0.0% 0.0% 0.0% 0.0% BALANCE SHEETS 29 Values transfer from the previous workshe $0 $0 $0 +30 Sol $0 0.0%SEE 0.0% SEE 0,0% SEE 0.0% 0.0% SEE 0.0% SEEN ASSETS 20 $1,050,500 50 $0 21 Cash Accorreceivable 50 10,499 300 32 $0 33 $0 14.612.200 inventory 50 34 $0 26,162,600 Total Current Assets $0 25 Not Fixed Assets 29.111,000 50 TOTAL ASSETS $55.281,100 50 $0 LIABILITIES & STOCKHOLDER'S EQUITY 31 39 Accounts payable 5,844,700 SC $0 33 Nutes wat 8.497.400 58.497.400 $8.497.400 Total current liabilities 14,342.100 $8,497.400 $8.497.400 31 Long term dat 12032.900 $13,032.900 312.032.900 TUTAL LIABILITIES 27,375,000 $21,530,300 $21,530,300 Common stock 2,750,000 $2,750,000 $2,750,000 Pelandang 25,155,100 $0 TOTAL STOCKHOLDERS' EQUITY 27.986.100 $2.750.000 $2.750.000 TOTAL LORO. 4 ... PRO FORMAS 2020 REQUIRED CORRECTIONS WACC Ready A you 40 Comed Sustain $0 $0 0.0%SEEWS 0.0 CAPITAL BUDGETING INST Type here to search O W e esc ? a # 7 $ % 2 3 4 5 6 tab w E R Caps lock A S D F G z

Answer & Explanation Solved by verified expert

See Answer