Texts: Need Excel formulas for the highlighted cells that aren't filled in. U H K M Z CORP MINI CASE Preferred Stock Par Value Coupon rate Coupon PMT Total Finance needed No of units $100 10.95% 50.00 Million Bonds with Warrants 10 Input Data 11 Par Value of bond 12 Warrants per bond 13 Value of each warrant 14 Total value of warrants 15 Stock Price 16 Growth rate 17 Strike Price on Warrants 18 Stepped up strike price 19 Expiration time for Warrants 20 Tax Rate 21 Straight bond Yield 22 Number of years 23 Coupon PMT 24 25 26 Year 0 1 27 Stock Price 20.00 21.40 28 PP if exercised 1200 1200 29 MP of Stock 1000.00 1070.00 30 Profits -200.00 -130.00 31 32 Profit on Warrants if exercised in 5 years 33 PV= -100 34 FV= 202.55 35 5 36 CPT I/Y 15.16% 37 38 After-tax Cost of bonds with Warrants for the issuer 39 PV -900 PMT 40 FV 1000N 41 1000 50 2 100 $20 7% 24 34 10 21% 12% 20.00 2 22.90 1200 1144.90 -55.10 3 5 6 7 8 9 10 24.50 26.22 28.05 30.01 32.12 34.36 36.77 39.34 1200 1200 1200 1700 1225.04 1310.80 1402.55 1500.73 1605.78 1718.19 1838.46 1967.15 25.04 110.80 202.55 1500.73 1605.78 1718.19 1838.46 267.15 Profits on Warrants if Exercised in 10 years PV -100 FV 267.15 N 10 CPT I/Y 10.33% I/Y
Added by Jorge R.
Close
Step 1
The highlighted cells that need Excel formulas are U27, U28, U30, U31, U33, U34, U36, U38, U40, and U41. Show more…
Show all steps
Your feedback will help us improve your experience
Akash M and 59 other Principles of Accounting educators are ready to help you.
Ask a new question
Labs
Want to see this concept in action?
Explore this concept interactively to see how it behaves as you change inputs.
Recommended Videos
The next dividend payment by Halestorm, Inc., will be $2.04 per share. The dividends are anticipated to maintain a growth rate of 4.5 percent forever. The stock currently sells for $37 per share. What is the dividend yield? What is the expected capital gains yield? Next year's dividend $ 2.04 Dividend growth rate 4.5% Stock price $ 37.00 Complete the following analysis. Do not hard code values in your calculations. Dividend yield Capital gains yield
Akash M.
How do you calculate the payment amount in Excel? I know how to do it by hand but am getting different answers with Excel formulas. Please specify which of the stated or market rates used.
Fill in the yellow highlighted cells with your forecasted figures. SHOW ALL YOUR SUPPORTING CALCULATIONS! You may do this either within the cell by using formulas, out to the right, or both -- clearly labeling your work. All your work must be shown on this sheet, not on a separate tab. Forecasted Income Statement (25 points) DURA-CLEAR WINDOWS, LLC Proforma Income Statement 2020 2021 2022 2023 2024 2025 2026 2027 Sales (all on credit) ########## 1,500,000 1,875,000 1,800,000 1,812,000 1,812,000 1,812,600 1,812,480 Cost of Goods Sold (800,000) (1,040,000) (1,105,000) Gross Profit 400,000 460,000 770,000 Selling and Administrative Expense (304,900) (350,500) (443,700) Operating profit (EBIT) 95,100 109,500 326,300 Interest expense (35,000) (45,000) (85,000) Net Income before Taxes 60,100 64,500 241,300 Taxes (36,900) (49,200) (55,600) Net Income 23,200 15,300 185,700 Shares 60,000 60,000 78,000 Earnings per Share $0.39 $0.26 $2.38
Recommended Textbooks
Horngren’s Cost Accounting
Cost Accounting A Managerial Emphasis
Principles of Accounting Volume 1: Financial Accounting
Transcript
Watch the video solution with this free unlock.
EMAIL
PASSWORD