How can I calculate the WACC (weighted average cost of capital) and operational cash flows...
50.1K
Verified Solution
Link Copied!
Question
Finance
How can I calculate the WACC (weighted average cost of capital) and operational cash flows based on this financial statement?
Decision Inputs for Quarter Number 1 Company Operating Decisions Units to be produced DEV. per common share Demand/price forecast Investment Decisions Short-term investment 100,000 $0.10 30 Per unit prio Advertising coat Sales discount $100.00 SO 0.008 Extraordinary Items Income before Taxes Income Tax (rate is 214) Income After Taxes Preferred Stock Dividind Earnings to Common Stockholdere Common Stock Dividenda ($0.10 per shaze Net Income Transferred to Retained Earnings $791,314 166,176 $625, 138 0 5625,138 $200,000 0 100.000 Risk of s- investment Units of plant bought Project 0 no 0 8525,138 Machine units bought Project A Pinancing Decisions Short-term loans Two-year loans Three-year loans Ten-year bonds Special Options Strike settlement (per he.) 80 $2,500,000 SO SO Preferred shares Common shares Common tender price 0 0 so $0.00 Dollar penalty so Quarterly Performance Report Quarter Number 1 $9,738,300 $9,740,662 $ 733,567 $2,000,000 3,500,000 85,500,000 560,400 478,125 1,300,000 200,000 2,038,532 7,538, 533 Sales revenue ( 97,383 units at $100.00) Income from securities Cost of Goods Sold: Beginning Inventory: (9,809 at $74.79 Materials Direct Labor Total Direct Coats Warehousing Coats Depreciation: Mach. and Equip. Plant Other Overhead Costa Total Indirect Costa Production Costa ( 100,000 at $75.39) Goods Available for Sale ! $75.33 per unit Less Ending Inventory 12,426 unita Cost of Goods Sold Gros Profit Selling and administrative expenses Financial Expenses: Short Term Bank Interest Penalty Loan Interest Intermediate Term Loan Interest Bond Interest Bond Redemption Costa Total Financial Charges Operating Income Before Extraordinary Items $8,272,100 936,072 7,336,028 $2,404,633 $1,486,915 $0 55 92,749 33, 600 126,404 1,613,319 $791,315 $33.09 1.194 1.1810 $12 198,092 6,524,661 936,072 Summary Data Quarter Number 1 HISTORICAL INFORMATION Common share price $32.99 Accumulated Wealth Quarterly EPS $0.63 Dividend Yield Price earnings ratio Marketable Security 13.19 Yield Actual unit price $100.00 Actual unit demand Preferred stock price $32.15 Preferred dividend yield Return on investment 14.868 Return on equity Call premium: preferred 8.00 Bond call premium Commons tender or sell/sh $0.00 Unpaid preferred dividend/share Outstanding dubt yielda: Short-tem 2-year loan 3-year loan Bonda 3.1108 2.500 1.400 INFORMATION FOR YUTURE QUARTERS: 97,383 3.118 22.58 8.000 $7,658,835 $0.00 $2,008, 125 7,165,250 9,173,375 $16.832.210 Penalty loan 8.000 on Position Statement Quarter Number 1 ASSETS Current Assets Cash Marketable Securities Accounts Receivable Inventory (12,426 units at $75.33 UNIT) Total Current Assets Fixed Assets (net of depreciation Machinery and Equipment Plant Total Fixed Assets Total Assets LIABILITIES AND OWNER EQUITY Current Liabilities Accounts Payable Short Term Loans Payable Short Term Penalty Loan Intermediate Term Debt Maturing Bonds Maturing Total Current Liabilities Long Term Liabilities Intermediate Loans: 2 years 3 years Bonda Total Long Term Liabilities Total Liabilities Owners' Equity Preferred Stock (0 shares Common Stock ( 1,000,000 shares) Retained Earnings Total Equity Total Liabilities and Equity $570,000 0 0 1,850,000 1,200,000 $3,620,000 $937,500 0 - 1.200.000 Plant 2,137,500 $5,757.500 Units forecast 105,721 103,295 123,736 117,871 Price per unit forecast $99.81 $103.73 $103.03 $102.85 Units of plant capacity 100,000 100,000 100,000 80,000 Units of machine capacity 100,000 100,000 75,000 60,000 Other Overhead 200,000 200,000 200,000 200,000 Depreciation Machinery 478,125 478,125 384,375 311,250 Projects 0 0 0 0 0 1,300,000 1,300,000 1,300,000 989,000 Principal repayment on debti Short-term 0 0 0 2-year 312,500 312,500 312,500 312,500 3-year 300,000 300,000 0 0 Bonda 300,000 300,000 300,000 300,000 Warehouse Lees: Unita First 2000 Next 5000 Over 7000 Cast/Unit / $1.00 $3.00 $8.00 Production costs per unit next quarter Materials $20.00 Machinery $47.00 Plant 8321.00 Units First 60,000 Next 40,000 Next 20,000 Over 120,000 Labor coat $39.00 $29.00 525.00 $33.00 $ 8,000,000 3,074,710 11,074,711 $16,832,210 Rates on funding in quarter 2 Short-term 2-year loan 1.905 1.8789 3-year loan 1.8545 Bond 1.8305 Preferred 2.286 Interest due next quarter: Short-term $0 Intermediate $83,030 Bonds $ $33,600 Capital budgeting projects for next quarter: Life Cast Unit capacity A 2-y $659,280 100,000 B 3-Y $513,432 120,000 Overhead Saving $15, 340 , -58, 102 Unit Laborav. QE1.2 30.62 80.85 Changa/tr. Labor Sav. $0.03 -$0.01 Decision Inputs for Quarter Number 1 Company Operating Decisions Units to be produced DEV. per common share Demand/price forecast Investment Decisions Short-term investment 100,000 $0.10 30 Per unit prio Advertising coat Sales discount $100.00 SO 0.008 Extraordinary Items Income before Taxes Income Tax (rate is 214) Income After Taxes Preferred Stock Dividind Earnings to Common Stockholdere Common Stock Dividenda ($0.10 per shaze Net Income Transferred to Retained Earnings $791,314 166,176 $625, 138 0 5625,138 $200,000 0 100.000 Risk of s- investment Units of plant bought Project 0 no 0 8525,138 Machine units bought Project A Pinancing Decisions Short-term loans Two-year loans Three-year loans Ten-year bonds Special Options Strike settlement (per he.) 80 $2,500,000 SO SO Preferred shares Common shares Common tender price 0 0 so $0.00 Dollar penalty so Quarterly Performance Report Quarter Number 1 $9,738,300 $9,740,662 $ 733,567 $2,000,000 3,500,000 85,500,000 560,400 478,125 1,300,000 200,000 2,038,532 7,538, 533 Sales revenue ( 97,383 units at $100.00) Income from securities Cost of Goods Sold: Beginning Inventory: (9,809 at $74.79 Materials Direct Labor Total Direct Coats Warehousing Coats Depreciation: Mach. and Equip. Plant Other Overhead Costa Total Indirect Costa Production Costa ( 100,000 at $75.39) Goods Available for Sale ! $75.33 per unit Less Ending Inventory 12,426 unita Cost of Goods Sold Gros Profit Selling and administrative expenses Financial Expenses: Short Term Bank Interest Penalty Loan Interest Intermediate Term Loan Interest Bond Interest Bond Redemption Costa Total Financial Charges Operating Income Before Extraordinary Items $8,272,100 936,072 7,336,028 $2,404,633 $1,486,915 $0 55 92,749 33, 600 126,404 1,613,319 $791,315 $33.09 1.194 1.1810 $12 198,092 6,524,661 936,072 Summary Data Quarter Number 1 HISTORICAL INFORMATION Common share price $32.99 Accumulated Wealth Quarterly EPS $0.63 Dividend Yield Price earnings ratio Marketable Security 13.19 Yield Actual unit price $100.00 Actual unit demand Preferred stock price $32.15 Preferred dividend yield Return on investment 14.868 Return on equity Call premium: preferred 8.00 Bond call premium Commons tender or sell/sh $0.00 Unpaid preferred dividend/share Outstanding dubt yielda: Short-tem 2-year loan 3-year loan Bonda 3.1108 2.500 1.400 INFORMATION FOR YUTURE QUARTERS: 97,383 3.118 22.58 8.000 $7,658,835 $0.00 $2,008, 125 7,165,250 9,173,375 $16.832.210 Penalty loan 8.000 on Position Statement Quarter Number 1 ASSETS Current Assets Cash Marketable Securities Accounts Receivable Inventory (12,426 units at $75.33 UNIT) Total Current Assets Fixed Assets (net of depreciation Machinery and Equipment Plant Total Fixed Assets Total Assets LIABILITIES AND OWNER EQUITY Current Liabilities Accounts Payable Short Term Loans Payable Short Term Penalty Loan Intermediate Term Debt Maturing Bonds Maturing Total Current Liabilities Long Term Liabilities Intermediate Loans: 2 years 3 years Bonda Total Long Term Liabilities Total Liabilities Owners' Equity Preferred Stock (0 shares Common Stock ( 1,000,000 shares) Retained Earnings Total Equity Total Liabilities and Equity $570,000 0 0 1,850,000 1,200,000 $3,620,000 $937,500 0 - 1.200.000 Plant 2,137,500 $5,757.500 Units forecast 105,721 103,295 123,736 117,871 Price per unit forecast $99.81 $103.73 $103.03 $102.85 Units of plant capacity 100,000 100,000 100,000 80,000 Units of machine capacity 100,000 100,000 75,000 60,000 Other Overhead 200,000 200,000 200,000 200,000 Depreciation Machinery 478,125 478,125 384,375 311,250 Projects 0 0 0 0 0 1,300,000 1,300,000 1,300,000 989,000 Principal repayment on debti Short-term 0 0 0 2-year 312,500 312,500 312,500 312,500 3-year 300,000 300,000 0 0 Bonda 300,000 300,000 300,000 300,000 Warehouse Lees: Unita First 2000 Next 5000 Over 7000 Cast/Unit / $1.00 $3.00 $8.00 Production costs per unit next quarter Materials $20.00 Machinery $47.00 Plant 8321.00 Units First 60,000 Next 40,000 Next 20,000 Over 120,000 Labor coat $39.00 $29.00 525.00 $33.00 $ 8,000,000 3,074,710 11,074,711 $16,832,210 Rates on funding in quarter 2 Short-term 2-year loan 1.905 1.8789 3-year loan 1.8545 Bond 1.8305 Preferred 2.286 Interest due next quarter: Short-term $0 Intermediate $83,030 Bonds $ $33,600 Capital budgeting projects for next quarter: Life Cast Unit capacity A 2-y $659,280 100,000 B 3-Y $513,432 120,000 Overhead Saving $15, 340 , -58, 102 Unit Laborav. QE1.2 30.62 80.85 Changa/tr. Labor Sav. $0.03 -$0.01
Answer & Explanation
Solved by verified expert
Get Answers to Unlimited Questions
Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!
Membership Benefits:
Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!