Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Multinational Financial Management

Authors: R M Srivastava

1st Edition

8174466703, 9788174466709

More Books

Students also viewed these Finance questions

Question

3 What are the four major aspects of an organisation culture?

Answered: 1 week ago

Question

2 What does the term organisation culture mean?

Answered: 1 week ago