Answered step by step
Verified Expert Solution
Question
1 Approved Answer
How would you preform a scenario analyses in excel? [1] use 10 years on basis of loan life and equipment life [2] half of previous
How would you preform a scenario analyses in excel?
[1] use 10 years on basis of loan life and equipment life | ||||||||||||
[2] half of previous year's growth rate until normalization | ||||||||||||
[3] historical cost of Associates | ||||||||||||
Service of Financing | ||||||||||||
Beginning debt | 320.0 | 288.0 | 256.0 | 224.0 | 192.0 | 160.0 | 128.0 | 96.0 | 64.0 | 32.0 | 0.0 | |
Interest payments | 19.2 | 17.3 | 15.4 | 13.4 | 11.5 | 9.6 | 7.7 | 5.8 | 3.8 | 1.9 | ||
Principal payments | 32.0 | 32.0 | 32.0 | 32.0 | 32.0 | 32.0 | 32.0 | 32.0 | 32.0 | 32.0 | ||
Other bank charges | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | ||
Lease payments | 52.6 | 54.2 | 55.8 | 57.5 | 59.2 | 61.0 | 62.8 | 64.7 | 66.6 | 68.6 | ||
Total service | 103.8 | 103.4 | 103.1 | 102.9 | 102.7 | 102.6 | 102.5 | 102.4 | 102.5 | 102.5 | ||
Tax shields | 21.5 | 21.4 | 21.3 | 21.3 | 21.2 | 21.2 | 21.1 | 21.1 | 21.1 | 21.2 | ||
Operating cash flow | 183.1 | 218.8 | 233.7 | 240.7 | 247.9 | 255.3 | 263.0 | 270.9 | 279.0 | 287.4 |
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