Question

In: Finance

Consider a firm with a contract to sell an asset for $220,000 seven years from now....

Consider a firm with a contract to sell an asset for $220,000 seven years from now. The asset costs $75,000 to produce today. Given a relevant discount rate on this asset of 7.5 percent per year, will the firm make a profit on this asset? (3 points )At what rate does the firm just break even? (3 points)

Solutions

Expert Solution

Solution:
a. Firm make a profit on this asset $ 57,606.08
Working Notes:
Firm make a profit on this asset
= Present value of sale value of 7th year today - cost today to produce
= (Sale value/(1+required rate of return)^n ) - cost today to produce
= (220000/(1+ 0.075)^7 ) - 75,000
= 132606.0782- 75,000
=$57,606.08
Now calculate this using Excel method
=PV(rate,nper,pmt, fv)
Here
PV= Present value of sale value of assets today =??
rate = 7.5%
nper= n = 7 years
pmt= 0 = any periodic cash flows
FV= sale value at end of 7 th year = $220000
=PV(rate,nper,pmt, fv)
=PV(7.5%,7,0, 220000)
($132,606.08) negative sign shows today present value outflows for payment of cash inflows in 7 th year of 220,000
Profit = Present value today -today cost to produce
Profit = 132,606.08 -75,000
Profit = $57,606.08
b. Rate for the firm just break even 16.62 %
Working Notes:
Rate for the firm just break even
to break even means profit is zero
present value 7th year sale value today is today cost to produce
let r be Rate for the firm just break even
Firm make a profit on this asset = 0
0= Present value of sale value of 7th year today - cost today to produce
0= (Sale value/(1+required rate of return)^n ) - cost today to produce
0= (220000/(1+ r )^7 ) - 75,000
75,000 =    220000/(1+ r )^7
(1+ r )^7 = 220,000/75,000
r = (220,000/75,000)^(1/7) - 1
r = 0.16618088
r = 16.62%
Now by excel method
=RATE(nper,pmt,pv,fv)
Here  
PV= Present value of sale value of assets today =-75000 cost to produce
rate = ??
nper= n = 7 years
pmt= 0 = any periodic cash flows
FV= sale value at end of 7 th year = $220000
=RATE(nper,pmt,pv,fv)
=RATE(7,0,-75000,220000)
16.62%
Please feel free to ask if anything about above solution in comment section of the question.

Related Solutions

Consider a firm with a contract to sell an asset for $155,000 four years from now....
Consider a firm with a contract to sell an asset for $155,000 four years from now. The asset costs $96,000 to produce today. a. Given a relevant discount rate on this asset of 14 percent per year, calculate the profit (or loss) the firm will make on this asset. (A loss should be indicated by a minus sign. Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) b. At what rate does the firm...
A contract is an agreement to buy or sell an asset. Discuss the difference between a...
A contract is an agreement to buy or sell an asset. Discuss the difference between a spot and a forward contract on a currency in terms of their features. (10 points)d
Daryl Kearns saved $220,000 during the 25 years that he worked for a major corporation. Now...
Daryl Kearns saved $220,000 during the 25 years that he worked for a major corporation. Now he has retired at the age of 50 and has begun to draw a comfortable pension check every month. He wants to ensure the financial security of his retirement by investing his savings wisely and is currently considering two investment opportunities. Both investments require an initial payment of $189,500. The following table presents the estimated cash inflows for the two alternatives: Year 1 Year...
Nemo deposits $7500 now, $5000 three years from now, and $1500 six years from now into...
Nemo deposits $7500 now, $5000 three years from now, and $1500 six years from now into a fund paying 8% compounded quarterly: What equal deposit of size A, made every 3 months (with the first deposit at t=0 and last deposit at the end of the 7th year) are equal to the 3 deposits?
Jimmy deposits $4,000 now, $2,500 3 years from now, and $5,000 6 years from now. Interest...
Jimmy deposits $4,000 now, $2,500 3 years from now, and $5,000 6 years from now. Interest is 5% for the first 3 years and 7% for the last 3 years. a) What is the uniform series equivalent of the fund (uniform cash flow at end of years 1 through 6)?
Question 3/ Firm C is planning its first dividend in 4 years from now. Firm C...
Question 3/ Firm C is planning its first dividend in 4 years from now. Firm C retention ratio is 65%. Firm C current net income is $2millions with 500,000 shares outstanding. The net income is expected to grow by 1% during the next 4 years. The dividends are expected to grow during year 5 by 11.5% and during year 6 by 9.5%. From year 6 to year 14 they is no expected growth in dividends. However starting from year 15...
Question 3/ Firm C is planning its first dividend in 4 years from now. Firm C...
Question 3/ Firm C is planning its first dividend in 4 years from now. Firm C retention ratio is 65%. Firm C current net income is $2millions with 500,000 shares outstanding. The net income is expected to grow by 1% during the next 4 years. The dividends are expected to grow during year 5 by 11.5% and during year 6 by 9.5%. From year 6 to year 14 they is no expected growth in dividends. However starting from year 15...
Question 3/ Firm C is planning its first dividend in 4 years from now. Firm C...
Question 3/ Firm C is planning its first dividend in 4 years from now. Firm C retention ratio is 65%. Firm C current net income is $2millions with 500,000 shares outstanding. The net income is expected to grow by 1% during the next 4 years. The dividends are expected to grow during year 5 by 11.5% and during year 6 by 9.5%. From year 6 to year 14 they is no expected growth in dividends. However starting from year 15...
Consider a worker who is planning to retire five years from now and is thinking about...
Consider a worker who is planning to retire five years from now and is thinking about not working for the next year and instead completing a one-year Master’s program. If they do not complete the program, they will earn $C one year from now, $C two years from now, and so on through five years from now. If they complete the program, they will pay $A one year from now and then earn $B each of the subsequent four years....
An investment will pay $381 two years from now, $620 four years from now, and $1,842...
An investment will pay $381 two years from now, $620 four years from now, and $1,842 five years from now. You are going to reinvest these cash flows at a rate of 11.19 percent per year. What is the future value of this investment at the end of year five?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT