Answered step by step
Verified Expert Solution
Question
1 Approved Answer
57 Prepare a DCF Analysis given the following assumptions 58 59 Operating Assumptions (for years 1-5) 60 5.0% 60.0% 10.0% 4.0% 36.0% 1.0% 5.0% 61
57 Prepare a DCF Analysis given the following assumptions 58 59 Operating Assumptions (for years 1-5) 60 5.0% 60.0% 10.0% 4.0% 36.0% 1.0% 5.0% 61 Revenue Growth 62 Cost of Revenue as % of Revenue 63 Oper. Expense as % of Revenue 64 Depreciation Expense as % of Revenue 65 Tax Rate 66 Working Capital Expense 67 Capex as % of Revenue 68 69 Risk Free 2.00% Historical Total Return 1196 71 2.00x 72 73 Interest and Principal Payments assumed that are paid at thet last day of the year Expected ero Year's Expected Return ources. Amount | % Capital WACC year's EBITDA Return (After Tax) Multiple 75 Bank Loan 5.00% 3.20% 150,000.00 50,000.00 200,000.00 400,000.00 76 Corporate Bonds 10.00% 6.40% 77 Equity 78 Total Sources 79 80 81 Bank Loan Information WACC 0 2 4 5 82 Amount Outstandin 83 Schedule Payments 84 Interest Payment 85 Total Financing Payment 18,000 20,00025,000 20,000 67,000 57 Prepare a DCF Analysis given the following assumptions 58 59 Operating Assumptions (for years 1-5) 60 5.0% 60.0% 10.0% 4.0% 36.0% 1.0% 5.0% 61 Revenue Growth 62 Cost of Revenue as % of Revenue 63 Oper. Expense as % of Revenue 64 Depreciation Expense as % of Revenue 65 Tax Rate 66 Working Capital Expense 67 Capex as % of Revenue 68 69 Risk Free 2.00% Historical Total Return 1196 71 2.00x 72 73 Interest and Principal Payments assumed that are paid at thet last day of the year Expected ero Year's Expected Return ources. Amount | % Capital WACC year's EBITDA Return (After Tax) Multiple 75 Bank Loan 5.00% 3.20% 150,000.00 50,000.00 200,000.00 400,000.00 76 Corporate Bonds 10.00% 6.40% 77 Equity 78 Total Sources 79 80 81 Bank Loan Information WACC 0 2 4 5 82 Amount Outstandin 83 Schedule Payments 84 Interest Payment 85 Total Financing Payment 18,000 20,00025,000 20,000 67,000
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started