Question 3 Capital Budgeting (25 Points) (Preamble: In the Midterm Question 1, you read that federal governments were printing money to finance spending for the war in Ukraine and for pandemic related spending, causing high inflation. In an article titled "LILLEY: Canada's delegation to Queen's funeral spent almost $400,000 for hotel rooms alone" in the Toronto Sun on October 24, 2022, we also know the federal government is printing money to finance luxury travel for politicians, imposing an "inflation tax" on Canadians.) After converting his office building in Montreal into a restaurant, Matthew found an even more lucrative investment to cater to luxury travel for politicians. He read in the Toronto Sun that the Canadian delegation to the Queen's funeral paid out a king's ransom for hotel rooms when the total bill at London's Corinthia hotel rang up at 281,400 pounds or $356,981.70 in Canadian dollars. Included in the detailed bill was a charge of 4,800 pounds per night for the River Suite with a view of the Thames and complimentary butler service, or $6,000 a night in Canadian dollars paid by taxpayers. Matthew is therefore considering cashing in more stock options and Pfizer shares to convert an office building he owns in Ottawa into a luxury hotel called the Athenia with numerous 1,000sqft suites with a view of the Rideau Canal costing $6,000 Canadian dollars a night, which, at that price, comes with complimentary butler and chauffeur service. First, Matthew has to dispose of old office equipment he bought at a capital cost of $2 million 10 years ago. When purchased, this old office equipment had an expected life of 25 years, at which time it was expected to have a salvage value of $200,000. The furniture and masonry for the Athenia together has a capital cost of $10 million dollars and an expected life of 15 years, with a salvage value of $1,000,000. Surprisingly, both the old office equipment and furniture and masonry belong to CCA asset class 8 . Revenue Canada requires that assets in this asset class be written off using the declining balance method at a CCA rate of 20%. The Athenia hotel is expected to generate increased pre-tax profits for Matthew of $2.4 million per year for 15 years after which Matthew will sell the building when the real estate bubble returns to Canada. No changes in net working capital requirements are expected. Currently the old office equipment could be sold for $400,000. Matthew's tax rate is 40% and he requires a rate of return of 15% to cover the opportunity cost of his Pfizer shares and stock options. For simplicity, all cash flows for a given year occur at the end of the year. a. What are the NPV and IRR of converting Matthew's Ottawa office building into the Athenia Hotel, doing the calculations by hand (with a calculator)? (12 points) Then input the numbers into the Excel spreadsheet "Use Solver or GoalSeek to get IRR-lecture 56 " (please download from eclass) and check your NPV and IRR calculations. b. Print out the page in pdf which shows the NPV calculated by Excel. You must submit this page. (1 point) c. Now use Solver to find the IRR. Print out the page in pdf which shows the IRR calculated by Goalseek or Solver. You must submit this page. (2 points) d. Suppose the pre-tax profit increase (from office building to hotel) is only $1.9 million in the first year. Using the same Excel spreadsheet, adjust the formulas to find the NPV break-even growth rate g of the pre-tax profit increase (using a growing annuity of revenues formula for present value of revenues). Print out the page in pdf which shows the growth rate calculated by Goalseek or Solver that yields a zero NPV. (10 points) Question 3 Capital Budgeting (25 Points) (Preamble: In the Midterm Question 1, you read that federal governments were printing money to finance spending for the war in Ukraine and for pandemic related spending, causing high inflation. In an article titled "LILLEY: Canada's delegation to Queen's funeral spent almost $400,000 for hotel rooms alone" in the Toronto Sun on October 24, 2022, we also know the federal government is printing money to finance luxury travel for politicians, imposing an "inflation tax" on Canadians.) After converting his office building in Montreal into a restaurant, Matthew found an even more lucrative investment to cater to luxury travel for politicians. He read in the Toronto Sun that the Canadian delegation to the Queen's funeral paid out a king's ransom for hotel rooms when the total bill at London's Corinthia hotel rang up at 281,400 pounds or $356,981.70 in Canadian dollars. Included in the detailed bill was a charge of 4,800 pounds per night for the River Suite with a view of the Thames and complimentary butler service, or $6,000 a night in Canadian dollars paid by taxpayers. Matthew is therefore considering cashing in more stock options and Pfizer shares to convert an office building he owns in Ottawa into a luxury hotel called the Athenia with numerous 1,000sqft suites with a view of the Rideau Canal costing $6,000 Canadian dollars a night, which, at that price, comes with complimentary butler and chauffeur service. First, Matthew has to dispose of old office equipment he bought at a capital cost of $2 million 10 years ago. When purchased, this old office equipment had an expected life of 25 years, at which time it was expected to have a salvage value of $200,000. The furniture and masonry for the Athenia together has a capital cost of $10 million dollars and an expected life of 15 years, with a salvage value of $1,000,000. Surprisingly, both the old office equipment and furniture and masonry belong to CCA asset class 8 . Revenue Canada requires that assets in this asset class be written off using the declining balance method at a CCA rate of 20%. The Athenia hotel is expected to generate increased pre-tax profits for Matthew of $2.4 million per year for 15 years after which Matthew will sell the building when the real estate bubble returns to Canada. No changes in net working capital requirements are expected. Currently the old office equipment could be sold for $400,000. Matthew's tax rate is 40% and he requires a rate of return of 15% to cover the opportunity cost of his Pfizer shares and stock options. For simplicity, all cash flows for a given year occur at the end of the year. a. What are the NPV and IRR of converting Matthew's Ottawa office building into the Athenia Hotel, doing the calculations by hand (with a calculator)? (12 points) Then input the numbers into the Excel spreadsheet "Use Solver or GoalSeek to get IRR-lecture 56 " (please download from eclass) and check your NPV and IRR calculations. b. Print out the page in pdf which shows the NPV calculated by Excel. You must submit this page. (1 point) c. Now use Solver to find the IRR. Print out the page in pdf which shows the IRR calculated by Goalseek or Solver. You must submit this page. (2 points) d. Suppose the pre-tax profit increase (from office building to hotel) is only $1.9 million in the first year. Using the same Excel spreadsheet, adjust the formulas to find the NPV break-even growth rate g of the pre-tax profit increase (using a growing annuity of revenues formula for present value of revenues). Print out the page in pdf which shows the growth rate calculated by Goalseek or Solver that yields a zero NPV. (10 points)