Assuming the formula given above is correct, compute the NPV of the cashflows from going ahead...
Fantastic news! We've Found the answer you've been seeking!
Question:
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/05/6647b88706abc_3266647b886dcfe2.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/05/6647b88771f1f_3276647b88741a98.jpg)
Transcribed Image Text:
Assuming the formula given above is correct, compute the NPV of the cashflows from going ahead with the sale and leaseback deal. Show your working. Compute the terms in the formula. Use this formula even if you believe it is incorrect. If you believe the formula given was incorrect then also compute the NPV of the cashflows based on your alternative formula. Write a spreadsheet to implement the formula(e) and explain your spreadsheet implementation of it. By show working we mean compute the 3 terms P, [R (1-t) a(n,j)], and [X (1+i)"] 9 marks (ii) Is this sale and leaseback arrangement equivalent to borrowing money or equivalent to lending money? Justify your answer. 6 marks Give a brief reason for your answer (iii) How would you decide on the interest rate to be used for discounting the differential cashflows for NPV or to be used as the hurdle rate for IRR analysis? Discuss this issue both in relation to this specific project and for projects generally. 5 marks Give a brief discussion about the issue of how to choose the interest rate for the valuation - what are the possibilities to consider? (iv) Which of the variables /parameters in the financial model/NPV for this project have the highest uncertainty attached to them? Which have the lowest uncertainty attached to them? Why? Give a brief reason for your answer 5 marks You work for a bank. One year ago the bank bought a new head office building in the central business district. The bank has now been approached by a large investor with the proposition that the bank should sell its head office and then lease it back under a 5 year lease, and that at the end of the sale and leaseback arrangement the bank will repurchase the building for a price agreed on in advance. Assume that the building is fully depreciated for tax purposes so that ownership of the building does not generate any depreciation expenses for tax purposes. (i) Using the assumptions set out in the table below, compute the after tax cashflows at times 0, 1, 2, 3, 4 & 5. Assuming that the risk free rate of interest is RF = 6% and the market risk premium is(RM - RF) = 6% and the beta of real estate is 1.5, compute the market required return i on a property investment proposal. Suppose that the bank can borrow money for a 5 year term at a rate of 10% p.a. before tax. P= $20,000,000.00 after tax sale proceeds from selling building t = n = R = e= 30.00% tax rate on income 5 term of deal $800,000.00 rent in year 1 of 5 year term 4.00% rental growth rate % p.a. X= $25,000,000.00 | assumed cost of buying back building at end of term Check whether it is true that the NPV is given by the formula below, and suggest how the formula may be modified if you believe the formula is incorrect. NPV=+P-[R (1-t) a(n, )] [X (1+1)*] where j = 1 and a(n,j) = (1-(1+1)=) 1+i 1+e State whether the formula is correct or not and if you think it is not correct suggest a correction to it Check whether it is true that the after tax cashflows are as shown in the table below, and state what the correct figures should be if any of the cashflows are incorrect: Time 0 1 2 3 4 5 cashflow $20,000,000 -$560,000 -$582,400 -$605,700 -$629,920 -$24,344,880 State whether the cashflows are correct or not and if you think it is not correct suggest what corrections are needed Assuming the formula given above is correct, compute the NPV of the cashflows from going ahead with the sale and leaseback deal. Show your working. Compute the terms in the formula. Use this formula even if you believe it is incorrect. If you believe the formula given was incorrect then also compute the NPV of the cashflows based on your alternative formula. Write a spreadsheet to implement the formula(e) and explain your spreadsheet implementation of it. By show working we mean compute the 3 terms P, [R (1-t) a(n,j)], and [X (1+i)"] 9 marks (ii) Is this sale and leaseback arrangement equivalent to borrowing money or equivalent to lending money? Justify your answer. 6 marks Give a brief reason for your answer (iii) How would you decide on the interest rate to be used for discounting the differential cashflows for NPV or to be used as the hurdle rate for IRR analysis? Discuss this issue both in relation to this specific project and for projects generally. 5 marks Give a brief discussion about the issue of how to choose the interest rate for the valuation - what are the possibilities to consider? (iv) Which of the variables /parameters in the financial model/NPV for this project have the highest uncertainty attached to them? Which have the lowest uncertainty attached to them? Why? Give a brief reason for your answer 5 marks You work for a bank. One year ago the bank bought a new head office building in the central business district. The bank has now been approached by a large investor with the proposition that the bank should sell its head office and then lease it back under a 5 year lease, and that at the end of the sale and leaseback arrangement the bank will repurchase the building for a price agreed on in advance. Assume that the building is fully depreciated for tax purposes so that ownership of the building does not generate any depreciation expenses for tax purposes. (i) Using the assumptions set out in the table below, compute the after tax cashflows at times 0, 1, 2, 3, 4 & 5. Assuming that the risk free rate of interest is RF = 6% and the market risk premium is(RM - RF) = 6% and the beta of real estate is 1.5, compute the market required return i on a property investment proposal. Suppose that the bank can borrow money for a 5 year term at a rate of 10% p.a. before tax. P= $20,000,000.00 after tax sale proceeds from selling building t = n = R = e= 30.00% tax rate on income 5 term of deal $800,000.00 rent in year 1 of 5 year term 4.00% rental growth rate % p.a. X= $25,000,000.00 | assumed cost of buying back building at end of term Check whether it is true that the NPV is given by the formula below, and suggest how the formula may be modified if you believe the formula is incorrect. NPV=+P-[R (1-t) a(n, )] [X (1+1)*] where j = 1 and a(n,j) = (1-(1+1)=) 1+i 1+e State whether the formula is correct or not and if you think it is not correct suggest a correction to it Check whether it is true that the after tax cashflows are as shown in the table below, and state what the correct figures should be if any of the cashflows are incorrect: Time 0 1 2 3 4 5 cashflow $20,000,000 -$560,000 -$582,400 -$605,700 -$629,920 -$24,344,880 State whether the cashflows are correct or not and if you think it is not correct suggest what corrections are needed
Expert Answer:
Posted Date:
Students also viewed these finance questions
-
Solve each equation. a. x = x b. x(x 8) = 4(x - 9) -
-
Leno Manufacturing Company prepared the following factory overhead cost budget for the Press Department for October 2014, during which it expected to require 20,000 hours of productive capacity in...
-
1. Can you identify some organizations that fit both of the criteria above? 2. Assume that Khan Academy wanted to move from being a nonprofit to a social enterprise. What products or services could...
-
What is meant by workload characterization? Give two ways in which auditors might seek to characterize a workload.
-
The KLM Christmas Tree Farm owns a plot of land with 5000 evergreen trees. Each year KLM allows retailers of Christmas trees to select and cut trees for sale to individual customers. KLM protects...
-
Productivity growth can be calculated by: ((current productivity - previous productivity) + (previous productivity)) 100 O input plus output divided by two. O outputs divided by the inputs. O inputs...
-
What is the output of the C program shown below? #include int main(void) { int x = 2, y = 3, z = 5; x = x + y; y = y* x; z = x + y; printf("%d and %d and %d ", x, y, z); x = 7 / 2; y = 10 % 4; z = 5...
-
In the Table below, the values found as a result of the sieving process of the A and B aggregates, which are made up of different groups, are given. Show whether the individual aggregates comply with...
-
Winnie Enterprises Ltd have an outstanding R1 000 par value bond, with 15 years to the maturity date. The bond pays a coupon at a rate of 6% per annum. Required: (i) (ii) (!!!) Calculate the value of...
-
Suppose that you are examining a company as a potential acquisition target. Your analyst did a DCF analysis, and you know that the company has a total (enterprise) value of $150 million. Your analyst...
-
2. What is the primary reason that we have three branches? Explain. So that not one person /group is making and enforcing all the laws.
-
Vertical 2.50 (H) Slot thru Depth of block 1.00 (L) x 8.00 (D) Slot thru bottom of block flush & centered in cutout Hexagon Circumscribed around 4.00 Circle centered on Cylinder thru entire block...
-
case study 2.2: Agency theoro: At the beginning of the current reporting period City Retail ltd launched a new logo and soent $500000 in new signage for all premises . the expenditure in signage was...
-
Transform the while loop from the previous exercise into an equivalent for loop (make sure it produces the same output).
![Mobile App Logo](https://dsd5zvtm8ll6.cloudfront.net/includes/images/mobile/finalLogo.png)
Study smarter with the SolutionInn App