Question
I have the answers but do not understand the steps to get there using excel. Please help!: Solve for the ideal interest rate given the
I have the answers but do not understand the steps to get there using excel. Please help!: Solve for the ideal interest rate given the following information: Term: 10 years; Loan amount: $1,000,000; Annual debt service: $200,000 c. 15% 2. What is the maximum amount of money that can be borrowed given the following terms? Term: 10 years; Annual debt service: $150,000; Interest rate: 10% d. $920,000 d (using =pv) 3. What is the ideal amortization rate (schedule) for the following loan? Loan amount: $500,000; Interest rate: 5%; Annual debt service: $115,487 b. 5 years (=nper(0.05,-115,487,500000) 4. Which of the following investments yields the highest IRR using a 15% discount rate? c. a $2,000 investment that provides $500 per year for 10 years (=pv(0.15,10,100)) (or, =irr(value,guess)) 5. What is the net present value of an investment that yields the following cash flows & could be sold for $10 million at the end of 5 years? Utilize a 10% discount rate. Year 1: 0; Year 2: $1,000,000; Year 3: $1,000,000; Year 4: $1,000,000 Year 5: $1,000,000 c. $9,000,000 c (=npv) 6. What is the debt service payment on a loan with the following terms? Loan amount: $100,000; Interest rate: 10%; Term: 7 years a. $20,541 7. Using the cap rate approach to valuation, if a restaurant generated $100,000 of cash flow last year and the WACC is 20%, at what price would the restaurant be valued? c. $500,000 8. If an investor is offered an opportunity to acquire an existing hotel for $10 million and he calculates its future value to be $15 million in 10 years and its present value to be $9 million, he would likely: b. not make the investment. (=pv(0.1, 10, 15000000) 9. If an investor is considering using 50% equity and 50% debt to finance a deal, his hurdle rate is 20% and the interest rate on the debt is 10%, what is his WACC? b. 15% 10. If an investor is offered an opportunity to invest $500,000 in a new restaurant and he calculates the present value of this investment to be $400,000 using his standard discount rate of 15%, the IRR on this potential investment would be: b. higher than 15%. (p 227 concept) 11. If 75% of a developer
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