Question

In: Finance

Durran has recently acquired a rare art piece that he plans to put on display in...

Durran has recently acquired a rare art piece that he plans to put on display in his private collection. He estimates that revenues generated from donations and admissions tickets to see the new exhibit will be $15,000 per year for the next five years. If he requires a rate of return of 9%, how much are the expected cash flows worth for him today? Round to two decimal places.

This is what I need: Show answers using the BA II Plus calculator (N, I/Y, PV, PMT, and FV)

(i) Develop the timeline (linear representation of the timing of cash flows)

(ii) Identify the time value of money variable which needs to be calculated in the question.

(iii) Identify the values of the remaining four variables (PV, FV, PMT, N or Rate) from the question. Be sure to input positive or negative signs.

(iv) Calculate the correct value of the variable identified in step (ii).

Expert Solution

(i) Develop the timeline (linear representation of the timing of cash flows) :

Durran estimates revenues of $15,000 per year for the next five years.

We will represent the cash flow diagram in Excel :

In the diagram the lines pointed upwards for each year from 1 to 5 represent Inflows of cash. r is the notation for the required rate of return.

(ii) Identify the time value of money variable which needs to be calculated in the question :

We need to find how much are the expected cash flows worth for him today, which is the Present Value of the expected cash flows, so the variable which needs to be calculated is the PV variable.

(iii) Identify the values of the remaining four variables :

PMT : the expected revenue per year = 15,000

N : the number of years for which cash flows are expected = 5

Rate (I/Y) = 9%

FV : Future Value of cash flows (not required in this case, hence zero)

(iv) Calculate the correct value of the variable identified in step (ii) :

Steps On the BA II Plus calculator :

First clear the TVM memory by pressing 2nd > FV.

First step : Press 5 then press N

Second : Press 9 then press I/Y

Third : Press 15000 then PMT

Fourth : Press 0 ("zero") then FV

Last : Press CPT , then PV

It should display PV = -58,344.76895 (ignore the negative sign)

Hence, the Present Value of the expected cash flows = $58,344.77 (rounded to two decimal places)

jeff jeffy answered 1 year ago

Redd is the owner of an art gallery in Amsterdam. He has what he has always...

Redd is the owner of an art gallery in Amsterdam. He has what he has always believed was a Rembrandt painting in his gallery. However, the Rembrandt Project has recently added this painting to the list they are currently reviewing, because they are of the opinion it may not be authentic. Learning this, Redd wants to sell the Rembrandt now before any official ruling on its authenticity. Redd remembered that his colleague, Blathers, was the curator for the Art Gallery...

NGD recently acquired a new piece of land in Suffolk County on April 1, 2012. The...

NGD recently acquired a new piece of land in Suffolk County on April 1, 2012. The land cost $5,000,000. NGD reports under IFRS and revalues its land. On December 31, 2017, the fair value of the land is $4,500,000. On December 31, 2020, the fair value of the land is $5,300,000. Provide all necessary journal entries for 2012 through 2020.

Mark, 25, plans to put $6,500 per year in his RRSP until age 65. He plans...

Mark, 25, plans to put $6,500 per year in his RRSP until age 65. He plans to invest the money in an index fund that is expected to earn a rate of return of 8% per year. When he retires at 65, he will withdraw the money in one lump sum, and pay taxes at the rate of 45%. His friend recommends that he should put his money in a TFSA, invest in the same index fund, and will end...

Your partner is dying from a rare disease. Luckily a cure has recently been invented, by...

Your partner is dying from a rare disease. Luckily a cure has recently been invented, by one druggist who lives fairly close to you. This druggist is selling the cure for ten times the amount it cost him to make it. You try to raise the money but even borrowing from friends to family and taking a loan from the bank, you can only raise half of the amount. You go to the druggist and offer to pay half now...

On December 15th, 2017, Star Inc. decided to put a piece of equipment that has a...

On December 15th, 2017, Star Inc. decided to put a piece of equipment that has a net book value of $430,000 on sale. One of the company’s shareholders showed interest in buying it for $400,000 and said that he was knowledgeable about the asset, which he intends to use in another business that he has. If Star Inc. accepts to sell the piece of equipment to the shareholder before its fiscal year end on December 31st, would you consider that...

Sterling, Inc. is a manufacturer of state-of-the-art computers. For the past ten years, Sterling has acquired...

Sterling, Inc. is a manufacturer of state-of-the-art computers. For the past ten years, Sterling has acquired all of its microchips from NoBugs Corporation, the only producer of chips meeting Sterling's high specifications. The relationship has been mutually profitable. Sterling could not have built its reputation as an industry leader without NoBugs's reliable and consistently high-quality products; Sterling's business has enabled NoBugs to grow rapidly while providing its investors with an attractive rate of return. Some months ago, several of Sterling's...

A bank has recently acquired a new branch and thus has customers in this new region....

A bank has recently acquired a new branch and thus has customers in this new region. They are interested in the default rate in their new region. They wish to test the hypothesis that the default rate is different from their current customer base. They sample 200 files in area A, their current customers, and find that 20 have defaulted. In area B, the new customers, another sample of 200 files shows 12 have defaulted on their loans. At the...

A bank has recently acquired a new branch and thus has customers in this new territory....

A bank has recently acquired a new branch and thus has customers in this new territory. They are interested in the default rate in their new territory. They wish to test the hypothesis that the default rate is different from their current customer base. They sample 81 files in area A, their current customers, and find that 48 have defaulted. In area B, the new customers, another sample of 103 files shows 72 have defaulted on their loans. What is...

Panera has recently acquired a new branch and thus has customers in this new territory. They...

Panera has recently acquired a new branch and thus has customers in this new territory. They are interested in the default rate in their new territory. They wish to test the hypothesis that the default rate is different from their current customer base. They sample 93 files in area A, their current customers, and find that 42 have defaulted. In area B, the new customers, another sample of 90 files shows 79 have defaulted on their loans. What is the...

Your uncle has 431,000 invested at 6.8% and he now wants to retire. He plans to...

Your uncle has 431,000 invested at 6.8% and he now wants to retire. He plans to withdraw $40,000 at the end of each year, beginning this year. How many years will it take to exhaust his funds, i.e., run the account down to zero?