Reference no: EM133069063
Assume that the cost of capital (discount rate) for the question that follows is equal to 0.18 (this is a decimal, not a percentage).
You are considering investing in a business that will cost $200,000 and will create free cash flows at the rate of $30,000 per year for the next 10 years. Your cost of capital was given in the first question. Use that cost of capital in this question.
Within Excel, compute the following and attach your file to this post.
-What is the payback of the project? If you require a payback under 7 years, do you accept or reject the project?
-What is the discounted payback of the project? If you require a discounted payback under 7 years, do you accept or reject the project?
-What is the internal rate of return of the project? Do you accept or reject the project given your cost of capital?
-What is the MIRR of the project? Do you accept or reject the project given your cost of capital?
-What is the NPV of the project? Do you accept or reject the project?Within the Excel spreadsheet, create an NPV profile of the project using interest rates from 0 to 20% at increments of 1%.
Attach your Excel spreadsheet as the answer to this question.
|
What is the amount of the arbitrage profit
: Assume the forward contract is actually trading at Php4800, rather than the no-arbitrage price. In this situation, we reverse the arbitrage trades and make an a
|
|
Determine the present value of the note
: The fair value of the services is not readily determinable and the note is not readily marketable. Determine the present value of the note
|
|
Building the excel model
: The Managing Director of an investment bank is responsible for the successful pitch to its valued clients. In this project we shall explore the entire process o
|
|
Find the monthly payment
: Question - Find the monthly payment in 2 years to settle a debt of P25,000 due now, if money is worth 12% compounded monthly
|
|
What is the mirr of the project
: Assume that the cost of capital (discount rate) for the question that follows is equal to 0.18 (this is a decimal, not a percentage).
|
|
Find the quarterly payments
: A personal computer being sold for P85,000 may be bought by making a P15,000 down payment, Find the quarterly payments
|
|
Find taxable income for the current year
: If her life expectancy is 8.33 years, what is her taxable income for the current year and next year?
|
|
What selling price per unit would it have established
: If Moody uses a markup percentage of 120% of its total manufacturing cost, then what selling price per unit would it have established for Job 400
|
|
Prepare an income statement for the month ended September
: The trial balance for Leek and Associates LLP is given below. Prepare an income statement for the month ended September 30th, 2018
|