Question

In: Accounting

Present Value. Use a calculator for each of these problems. (a) You are moving to Bozeman...

Present Value. Use a calculator for each of these problems.

(a) You are moving to Bozeman and you are going to stay here forever. You would like to find an apartment. You can either buy it or rent it. The monthly rent is $500 and the monthly interest rate is 0.1%. Alternatively, you can purchase the apartment, paying $600,000. How are you going to finance your new accommodation? Argue using the PV formula.

(b) You take a loan to buy a car that costs $4000. What is your monthly payment if you want to pay back the loan after 3 years (36 payments) and the monthly interest rate is 0.5%. (Hint: think annuity)

(c) You are hired by Merrill Lynch to help assess the value of a T-bond (a bond issued by the Treasury Department) with the face value F=$1000, coupon c = $100 (paid anually until T − 1 and face value F paid at time T) and time to maturity equal to T = 10 years. The interest rate is equal to r = 10%. Find the PV of such a bond. Is it a good or bad deal to buy such a bond for $900? Explain.

(d) You want to receive $40,000 per year when retired (you will be retired from 61-80). How much do you have to save between 21-60 years if the interest rate is 5%?

(e) You save $20,000 per year when working and plan to work from 21-60. How much will you consume per year when you retire? Assume you will be retired from 61-80. The interest rate is 5%.

Solutions

Expert Solution

Part a) Rent vs buy decision

This is classic example of Perpetuity. Since Mr. Bozeman is intending to settle permanently. There will be perpetual cash outflows of monthly rent for him.

Present value of a perpetuity = Perpetuity/Discount rate

Here, if he rents PV of Perpetuity = (500)/0.001 = (5,00,000)

In case of buying the property, Bozeman needs to take a loan of $6,00,000 at 0.1% monthly interest rate. Here the repayment length is not given so lets assume 5 years.

Now we need to calculate Present value of interest payments for 5 years

Annual Interest rate = 0.1% *12 = 1.2%

Annual interest payments = $6,00,000 *1.2% = $7200

On summation of PV of outflows using PVF of 1.2% we have PV of CAsh outflow = 5997+4997+4162 + 3470 +2887 = ($21513)

Here we cannot compare PV of perpetuity and PV of interest outflows directly because of time difference. However, we must go with buying the house through mortgage financing as rental will be perpetual and Interest outflows will come to an end by 5 years or Loan period. Additionally, there will be a terminal sale value of the house in case of purchase which wont be there in case of renting the house.

Part b) Calculation of Monthly payments using Annuity

Loan amount $4000

Monthly interest rate = 0.5% or 6% Annual interest rate = r

No of time periods = 36 months or 3 years

Annual installment = Loan amount/PVFAi,r

Therefore, taking PVFA3,0.06 from the annuity table = 2.673

Annual installment = 4000/2.673 = $1496

Monthly installment would be = 1496/12 = $125

Part c) Present value of the bond

Bond value = Present value of interest + Present value of Maturity value

Face value of the bond = $1000

Coupon rate = REquired rate of return for investor = 10%

Time = 10 years, Interest payments till Year 9 $100 every year.

Below is the table showing both the values for 10 years

year Inflow PVF(r=10%) PV
1 100 0.909 90.9
2 100 0.826 82.6
3 100 0.751 75.1
4 100 0.683 68.3
5 100 0.62 62
6 100 0.564 56.4
7 100 0.513 51.3
8 100 0.466 46.6
9 100 0.424 42.4
10 1000 0.385 385

Present value of the bond

$960.6

As we observe that the Present value of inflows from the bonds is higher than the buy price of $900, it is a good deal for investor to buy it now.

Part e) Yearly consumption on retirement

Yearly saving = 20,000 for 19 years

Rate of interest = 5% or 0.05

Future value of Savings = Savings *( 1+i)n

FV = 20,000 * (1+0.05)39

Taking CVF for 39 years = 6.705

FV = $134100

Number of years retired = 80-61 = 19 years

Therefore savings which can be used per year = 134100/19 = $7058


Related Solutions

Each question will be labeled as a calculator or formula question. For calculator problems , you...
Each question will be labeled as a calculator or formula question. For calculator problems , you are to label and input all the variables of interest: N, I/Y, PV, PMT, FV (and Begin mode if you switch). the unknown variable should be indicated by a ? symbol. Once solved, rewrite the variable identifier with the correct answer. For the formula problems, set up the problem and solve. Be sure to show each step for credit. Answer each question in BB...
Do the following present value problems. You must set up all present value problems before calculation....
Do the following present value problems. You must set up all present value problems before calculation. Merely writing down the answer (even if it is correct) is an automatic zero. You must show your work. a. Suppose we have a four year fixed-payment loan with $1000 payments made at the end of each year. Given a market interest rate of 12 percent, how much was initially borrowed? b. Suppose you were considering purchasing a $5000 machine today that would generate...
Business Applications. Find the present value (principal) or the compound interest, as indicated. Use a calculator...
Business Applications. Find the present value (principal) or the compound interest, as indicated. Use a calculator or Table 16-1 or Table 16-2 to find FVF or PVF. Round answers to the nearest cent. show entire solution please. 16. Bill Starnes needs to buy another used logging truck. His mother will loan him part of the money at 3% compounded quarterly. If Bill estimates that he will be able to repay his mother a total of $30,000 in 2 1/2 years,...
Using a Calculator and Present Value Table to Impute Interest Rate and Determine Present Value of...
Using a Calculator and Present Value Table to Impute Interest Rate and Determine Present Value of Operating Leases AutoZone reports the following in its 2015 Form 10-K. The Company leases some of its retail stores, distribution centers, facilities, land and equipment, including vehicles. Other than vehicle leases, most of the leases are operating leases... The Company has a fleet of vehicles used for delivery to its commercial customers and stores and travel for members of field management. The majority of...
Calculating present and future values Use future or present value techniques to solve the following problems....
Calculating present and future values Use future or present value techniques to solve the following problems. If you inherited $60,000 today and invested all of it in a security that paid a 6 percent rate of return, how much would you have in 20 years? Round the answer to the nearest cent. Round FV-factor to three decimal places. Calculate your answer based on the FV-factor. $   Calculate your answer based on the financial calculator. $   If the average new home...
Instructions: You are required to use a financial calculator or spreadsheet (Excel) to solve the problems...
Instructions: You are required to use a financial calculator or spreadsheet (Excel) to solve the problems (provided on page 4) related to risk and return characteristics and stock/bond valuation. You are required to show the following three steps for each problem (sample problems and solutions are provided for guidance): (i) Describe and interpret the assumptions related to the problem. (ii) Apply the appropriate mathematical model to solve the problem. (iii) Calculate the correct solution to the problem. A company’s stock...
eBook Calculator Net Present Value Method, Present Value Index, and Analysis for a service company Continental...
eBook Calculator Net Present Value Method, Present Value Index, and Analysis for a service company Continental Railroad Company is evaluating three capital investment proposals by using the net present value method. Relevant data related to the proposals are summarized as follows: Maintenance Equipment Ramp Facilities Computer Network Amount to be invested $996,044 $583,354 $311,735 Annual net cash flows: Year 1 413,000 277,000 190,000 Year 2 384,000 249,000 131,000 Year 3 351,000 222,000 95,000 Present Value of $1 at Compound Interest...
You are required to use a financial calculator or spreadsheet (Excel) to solve 10 problems related...
You are required to use a financial calculator or spreadsheet (Excel) to solve 10 problems related to the cost of capital. You are required to show the following 3 steps for each problem: (i) Describe and interpret the assumptions related to the problem. (ii) Apply the appropriate mathematical model to solve the problem. (iii) Calculate the correct solution to the problem. Round all answers to two decimal places. Lee Airlines plans to issue 25-year bonds with a par value of...
You are required to use a financial calculator or spreadsheet (Excel) to solve 10 problems related...
You are required to use a financial calculator or spreadsheet (Excel) to solve 10 problems related to the cost of capital. You are required to show the following 3 steps for each problem: (i) Describe and interpret the assumptions related to the problem. (ii) Apply the appropriate mathematical model to solve the problem. (iii) Calculate the correct solution to the problem. Round all answers to two decimal places Fisheye Inc. is investing in a new project costing $20 million. It...
You are required to use a financial calculator or spreadsheet (Excel) to solve 10 problems related...
You are required to use a financial calculator or spreadsheet (Excel) to solve 10 problems related to the risk and return, stocks and bonds valuation. You are required to show the following 3 steps for each problem: (i) Describe and interpret the assumptions related to the problem. (ii) Apply the appropriate mathematical model to solve the problem. (iii) Calculate the correct solution to the problem. 1. A $1,000 par value 8-year bond with a 13 percent coupon rate recently sold...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT