Question

In: Finance

SHOW WORK ON EXCEL: You are considering an investment that will pay you $12,000 the first...

SHOW WORK ON EXCEL: You are considering an investment that will pay you $12,000 the first year, $13,000 the second year, $17,000 the third year, $19,000 the fourth year, $23,000 the fifth year, and $28,000 the sixth year (all payments are at the end of each year). What is the maximum you would be willing to pay for this investment if your opportunity cost is 11%?

Solutions

Expert Solution

the maximum you would be willing to pay for this investment is nothing but present value of future expected cash flows

Year Cashflow PVF@11% Cashflow*PVF
1                12,000 0.9009 10810.81
2                13,000 0.8116 10551.09
3                17,000 0.7312 12430.25
4                19,000 0.6587 12515.89
5                23,000 0.5935 13649.38
6                28,000 0.5346 14969.94

Present Value = Cashflow*PVF

= 10810.81+10551.09+12430.25+12515.89+13649.38+14969.94

= $74927.37

Formula to calculate PV in excel is as follows

"=PV(interest rate,Year,0,cashflow)"

You can use the equation 1/(1+i)^n to find PVF using calculator


Related Solutions

Solve in Excel. Show formulas A) You are considering an investment that will pay you $12,000...
Solve in Excel. Show formulas A) You are considering an investment that will pay you $12,000 the first year, $13,000 the second year, $17,000 the third year, $19,000 the fourth year, $23,000 the fifth year, and $28,000 the sixth year (all payments are at the end of each year). What is the maximum you would pay for this investment if your opportunity cost is 12%? B) You are considering an investment that will pay you $12,000 the first year, $13,000...
1) You are considering an investment that will pay you $12,000 the first year, $13,000 the...
1) You are considering an investment that will pay you $12,000 the first year, $13,000 the second year, $17,000 the third year, $19,000 the fourth year, $23,000 the fifth year, and $28,000 the sixth year (all payments are at the end of each year). What is the maximum you would be willing to pay for this investment if your opportunity cost is 11%? 3)How much would you be willing to pay for an investment that will pay you and your...
1) You are considering an investment that will pay you $12,000 the first year, $13,000 the...
1) You are considering an investment that will pay you $12,000 the first year, $13,000 the second year, $17,000 the third year, $19,000 the fourth year, $23,000 the fifth year, and $28,000 the sixth year (all payments are at the end of each year). What is the maximum you would be willing to pay for this investment if your opportunity cost is 11%? Solve this question assuming that payments will be received at the beginning of each year rather than...
show Excel ( show all work including formulars ) You are considering an investment in the...
show Excel ( show all work including formulars ) You are considering an investment in the stock market and have identified two potential stocks, they are Westpac Banking Corp. (ASX: WBC) and Singapore Airlines Ltd. (SGX: C6L). The historical prices for the past 10 years are shown in the table below. in the table below. Year ASX: WBC SGX: C6L 2009 23.70 13.82 2010 22.85 14.76 2011 21.01 11.1 2012 27.85 10.99 2013 30.66 9.59 2014 34.23 12.65 2015 30.85...
Please show work step by step, NO EXCEL. Thank you! The investment is $1,000,000, which is...
Please show work step by step, NO EXCEL. Thank you! The investment is $1,000,000, which is depreciated straight line to a zero salvage value over a 10 year life. The asset will be worthless in 10 years. The project will generate, annually, revenues of $800,000, cash operating expenses of $500,000, and depreciation of $100,000. The tax rate is 30%, and the cost of capital is 10%. a. what are the annual cash flow and the NPV? b. what would be...
Show Work, Please. Excel Preferably. Suppose you are considering investing in a new business that will...
Show Work, Please. Excel Preferably. Suppose you are considering investing in a new business that will cost $10 million. A bank is willing to lend you $7 million for the purchase with equity holders having to provide the remainder of the funds. the terms of the loan are: a 20-year loan with yearly payments at a fixed rate of 3%. You will sell the business after year 8. You estimate the business will have the following profits in years 1-8:...
Show work (excel if possible but show formulas you used in excel): If I buy a...
Show work (excel if possible but show formulas you used in excel): If I buy a new car and pay $399 a month for 5 years and the maintenance costs are $50 the first year and increase by $200 a year for each year after that, how much money would I have to barrow today at a nominal interest rate of 9% to cover my monthly payment and my yearly maintenance bill?
Show work (excel if possible but show formulas you used in excel): If I buy a...
Show work (excel if possible but show formulas you used in excel): If I buy a new car and pay $399 a month for 5 years and the maintenance costs are $50 the first year and increase by $200 a year for each year after that, how much money would I have to barrow today at a nominal interest rate of 9% to cover my monthly payment and my yearly maintenance bill?
please show your work and formula on excel You can afford to pay $375 monthly car...
please show your work and formula on excel You can afford to pay $375 monthly car payments. Assume an annual interest rate of 6%, and assume 60 monthly payments. You can afford to put down $3,000. Can you afford to buy a car that costs $30,000?
A- Annuity Present Value -You are looking into an investment that will pay you $12,000 per...
A- Annuity Present Value -You are looking into an investment that will pay you $12,000 per year for the next 10 years. If you require a 15 percent return, what is the most you would pay for this investment? B- Describe how to calculate the future value of a series of cash flows. C- Describe how to calculate the present value of a series of cash flows.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT