Can you please help with lesson 5.1 and 5.2 file is attached

FNCE 300/ECON 300: Assignment 2 Due: After completion of Lesson 8. Marks: 100 Credit Weight: 20% of final grade. Prepare your responses to these assignment problems in a word processing file. As you complete the assignment problems for each lesson, add your responses to this file. Be sure your name, the course, and assignment number are part of the filename, and do not use spaces in your assignment filename. Submit Assignment 2 for grading when you have completed all the questions from Lessons 5, 6, 7, and 8. Please show all calculations to four decimal places. Question 5.1 5.2 5.3 5.4 5.5 6.1 6.2 7.1 7.2 8.1 8.2 8.3 Total FNCE/ECON 300 v2 Available Marks 3 7 7 6 10 12 7 10 6 4 20 8 100 1 June 2019 Lesson 5: Household Saving and Investment Decisions Use the following information for 5.1 and 5.2 Equation 5.2 in the textbook shows the intertemporal budget constraint. In words, the equation states that the present value of all the consumption over a person's lifetime plus the present value of any bequests that person gives to other people over her lifetime must be equal to the sum of the person's starting wealth plus the present value of labour income earnings over her lifetime. Note: The uppercase sigma (the one that looks like a big E) tells you to sum all of the instances of the variable (Ct, Bt, or Yt) over all t from t=1 to t=T, where T is the total number of years in the remaining lifetime of the person considered. This sum can be calculated using the TVM (Time Value of Money) buttons on your calculator, or with the TVM functions in an Excel spreadsheet. Data for your assignment questions: 5.1 Assume you have $1 million now, and you have just retired from your job. This would be your initial wealth, W 0. You expect to live for 20 years, and you want to have the same level of consumption for each of the 20 years, after adjusting for inflation. That is, you want to keep the same purchasing power of consumption for all 20 years. In the equation, this means that Ct will be constant in real dollars over the rest of your lifetime. You also wish to leave the purchasing power equivalent of $100,000 today to your kids at the end of the 20 years as a bequest (or to pay them to take care of you). In real dollars, of course, since there is no inflation in real dollars, you will need to have $100,000 to give them at the end of the 20 years. You expect real interest rates to stay at 5% per year. So, your savings account will earn 5% in real dollars over the next 20 years. The Omar example in the textbook shows Omar's human capital through labour earnings, but our assignment problem does not have any labour earnings. You have already earned your retirement savings of $1 million. The assignment problems will ask you to apply the formula to calculate the level of consumption that fits the intertemporal budget constraint, given assumptions about initial wealth and a planned bequest. (3 marks) FNCE/ECON 300 v2 2 June 2019 a. Calculate the present value of your bequest of $100,000 in real dollars. (1 mark) b. Determine the constant value of consumption that equates the value of your initial wealth on the right side of the equation with the total of consumption and your bequest. (2 marks) Hint: To do this, you need to recognize that the equation contains an annuity for future consumption. The bequest is a single lump sum value, and the initial wealth is already stated at present value. The present value of labour income is zero. Use this information to determine 5.2 i. the present value of consumption for all 20 years. ii. use that value to determine the annual consumption for each of the 20 years. This part is very similar to the last question on Assignment 1. Intertemporal Budget Constraint with Nominal Cash Flows (7 marks) Using the same information as stated in 5.1 and adding the assumption that inflation is expected to be 3% per year over the next 20 years, translate all of the values (i.e., the bequest, the initial wealth, and the consumption, into nominal dollars (i.e., actual dollars rather than purchasing power). The trickiest part is the fact that the consumption amount will no longer be constant, because inflation will require that you spend 3% more each year to maintain the same consumption. So, if you spent $1 last year to buy a chocolate bar, the same chocolate bar will cost you $1.03 at the end of year 1, $1.0609 at the end of year 2 (i.e., 1.0609 = 1.03 x 1.03 = 1.03^2), and so on. a. The present value of your bequest will be the same as in part 5.1a, because the present value of the nominal amount must be the same as the real amount at time 0. But in 20 years, the real amount of $100,000 will not be the same as the nominal amount. Calculate the nominal amount you will need to have 20 years from now to satisfy the bequest for your kids. (2 marks) Hint: One way to visualize how to do this is to realize that $100,000 of purchasing power is no different than the price of 100,000 $1 chocolate bars today. All you need to do is determine how much you'd have to pay to buy the same chocolate bars 20 years in the future. b. Calculate the actual amount of consumption, in nominal dollars, for each of the 20 years, using the stated assumptions. This requires you to calculate 20 numbers, so you might want to use an Excel spreadsheet, such as the one provided with this assignment (5.2 template). (4 marks) Note: If you want to calculate the result algebraically, you could use the FNCE/ECON 300 v2 3 June 2019 formula for the present value of a growing annuity. You can find the formula in the lesson notes at the end of Note 7 in Lesson 4. That formula shows the value of a $1 annuity, which grows to a value of (1+g) at the end of the first period, and then grows at a rate of g every year after that first period. In your assignment solution, tell us the amount of consumption at the end of the first year and at the end of the 20th year. You can cut and paste the table from your Excel spreadsheet, or you can show your calculations algebraically. c. 5.3 Many financial planners use real rates to plan for their clients' retirements. Given your recent experience with questions 5.1 and 5.2, why might they use real rates rather than nominal rates? (1 mark) (7 marks) a. Eighteen-year-old Linus is thinking about taking a five-year university degree. The degree will cost him $25,000 each year. After he's finished, he expects to make $50,000 per year for 10 years, $75,000 per year for another 10 years, and $100,000 per year for the final 10 years of his working career. All these values are stated in real dollars. Assume that Linus lives to be 100 and that real interest rates will stay at 5% per year throughout his life. i. Calculate the present value of his lifetime earnings. (1 mark) ii. Calculate the present value of the cost of his schooling. (1 mark) iii. Subtract the present value of the schooling cost from his lifetime labour earnings to determine his human capital. Use that value to determine his permanent income, that is, the equal annual consumption Linus could enjoy over the rest of his life. (1 mark) b. Linus is also considering another option. If he takes a job at the local grocery store, his starting wage will be $40,000 per year, and he will get a 3% raise each year, in real terms, until he retires at the age of 53. Assume that Linus lives to be 100. c. i. Calculate the present value of Linus's lifetime earnings, using a spreadsheet or using the growing annuity formula. You can find the formula in the lesson notes, at the end of Note 7 in Lesson 4. (1 mark) ii. Use that value to determine Linus's permanent income, i.e., how much can Linus spend each year equally over the rest of his life? (1 mark) Do you think Linus is better off choosing option a. or option b.? Consider both financial and non-financial measures. (2 marks) FNCE/ECON 300 v2 4 June 2019 5.4 In this question, we answer the age-old query, \"Are we better off playing the lottery or saving the money?\" (6 marks) Assume you can buy one ticket for $5, draws are made monthly, and a winning ticket correctly matches six different numbers of a total of 49 possible numbers. The probabilities: To win, you must choose all six numbers correctly. Your first number has a one in 49 chance of being correct. Your second number has a one in 48 chance, and so on. There are exactly 49x48x47x46x45x44... = 10,068,347,520 ways to pick six numbers from 49 options. The order in which you pick them does not matter, though, so you actually have a few more ways to win. You can pick six different numbers in exactly 6x5x4x3x2x1 = 720 orders of choice. Any of those orders would still win the lottery. Putting this all together, your ticket has 720/10,068,347,520 = 1/13,983,816 chance of winning. This equates to a .000000071 percentage chance. If you played one ticket every month from age 18 to age 65, you would have 47x12 = 564 plays. Your odds of never winning would be calculated using a binomial distribution to be .9999599568, meaning your chances of winning would be 1-.9999599568 = .0000400432. So, if the lottery winnings averaged $10 million over this time period, your expected return would be less than .0000400432 x $10 million = $400.43. (It's actually less than $400.43 because your 564 plays are spread out over the next 47 years, so the present value of these future plays would be significantly less than if you were able to play all 564 immediately. The $400.43 assumes you play all 564 plays today, which makes it the highest possible expected value.) a. What would your $400.43 be worth if you invested it at an annual real interest rate of 1% (with monthly compounding) for 47 years? (1 mark) b. If, instead, you deposited your five dollars per month in a bank at 1% real interest rate with monthly compounding, how much would you have at the end of the first year? (1 mark) c. If you did this every year for 47 years at the 1% real interest rate with monthly compounding, how much would you have at age 65? (1 mark) d. How much better off would you be keeping your money, rather than playing the lottery? (1 mark) e. 5.5 If, instead of 1%, you earned 5% real interest on your deposits, how much would you have at age 65? (2 marks) You may use the Excel spreadsheet named LeasevsBuy.xls to answer the FNCE/ECON 300 v2 5 June 2019 following question. If you choose to answer the question without using the spreadsheet, be careful to show all work, so your marker can follow your calculation and award partial marks as needed. (10 marks) You want to acquire a new car, but you're not sure whether you should lease it or buy it. You can buy your chosen model for $50,000. You expect it to be worth $20,000 after you use it for three years. Alternatively, you could lease it for $650 per month for a three-year term, with the first payment due immediately. The lease company has not told you what interest rate they're using to calculate the monthly payments, but you know you could borrow money at an annual percentage rate (APR) of 8%. a. Calculate the present value of the lease payments, assuming monthly compounding at the given APR of 8%. (2 marks) b. Calculate the present value of the $20,000 salvage value, again using monthly compounding and the given APR of 8%. Deduct the salvage value from the purchase price to determine the present value of the cost of buying the vehicle. (2 marks) c. Based on your calculations, which option do you prefer: lease or buy? (2 marks) d. Calculate the salvage value at which you should be indifferent between leasing and buying. (2 marks) e. Assume your tax rate is 40%. If you were to use this car 100% for business, rendering the lease payments tax-deductible, or alternatively, allowing you to deduct depreciation straight-line at $10,000 per year for three years, would you prefer to buy or lease the car? (Hint: Use the aftertax borrowing rate to discount the cash flows.) (2 marks) FNCE/ECON 300 v2 6 June 2019 Lesson 6: The Analysis of Investment Projects You may use the Excel spreadsheet named Chapter6_template.xls to answer the following question. If you choose to answer the question without using the spreadsheet, be careful to show all work, so your marker can follow your calculation and award partial marks as needed. To ensure that you know how the spreadsheet works, it is recommended that you replicate Table 6.5 (textbook p. 182). A completed spreadsheet for Table 6.5 is included with the template file as a separate worksheet, so you can check your work. 6.1 You and your friends are thinking about starting a motorcycle company named Apple Valley Choppers. Your initial investment would be $500,000 for depreciable equipment, which should last five years, and your tax rate would be 40%. You could sell a chopper for $10,000, assuming your average variable cost per chopper is $3000, and assuming fixed costs, such as rent, utilities, and salaries, would be $200,000 per year. (12 marks) a. Accounting breakeven: How many choppers would you have to sell for net income to equal zero, ignoring the costs of financing? (1 mark) f. Financial breakeven: How many choppers would you have to sell to generate NPV of zero, if you required a 15% return? (Hint: Use the 15% as the discount rate and calculate net present value. In Excel, you may want to use the Goal Seek command, or simply use trial and error to find the correct amount.) (2 marks) g. Assuming you could sell 60 choppers per year, what would be your IRR? (2 marks) h. Assuming you could sell 60 choppers per year, what would your selling price have to be to generate a net present value of $150,000 at a 15% discount rate? (2 marks) i. If you could sell 60 choppers in the first year, and your sales volume increased by 5% each year until the end of year five, what would the net present value be at a 15% discount rate? (2 marks) j. If, at the beginning of each year, you expect to need working capital equal to 10% of the next (coming) year's sales revenue, what would be the effect on the net present value of the project? Only changes in the amount of working capital require cash flows. Assume a sales price of $10,000 per chopper and a sales quantity of 60 choppers. (2 marks) Remember that any money invested in working capital (i.e., inventory, accounts receivable, accounts payable) would usually be recovered in its entirety at the end of the project. FNCE/ECON 300 v2 7 June 2019 k. 6.2 Do you think that the need for working capital always reduces the net present value of projects? Can you think of circumstances where working capital could increase the NPV of a project? (Hint: Think of airline tickets purchased in advance.) (1 mark) Complete the following table. Assume that the real interest rate is 3% per year, and inflation is expected to be constant at 2% per year. Recall that nominal cash flows must be discounted using nominal rates, and real cash flows must be discounted using real rates. (7 marks) Year Nominal cash flow Real cash flow 0 -100,000 -100,000 1 + 12,000 2 +22,000 3 +15,000 4 +10,000 Net present value Discount rate 3% Note that present values are taken at time 0, at which point real cash flows and nominal cash flows are the same, because there is no time for inflation to affect the cash flows. This implies that the present values of the two series of cash flows should be exactly the same. Hint: You may want to recall the $1 chocolate bar example from question 5.2 to assist you with calculating the real cash flows. Note that you can use the CF function of the Texas Instruments BA II Plus calculator (similar on the HP 10BII series and Sharp EL738 series financial calculators) to calculate the NPV of these cash flows. See your user's manual or a YouTube video to learn how to use this function. FNCE/ECON 300 v2 8 June 2019 Lesson 7: Principles of Market Valuation 7.1 Find a website that shows exchange rates for all major international currencies. One such site is XE.com. Another is oanda.com. (10 marks) a. What is the current exchange rate between the Canadian dollar and the US dollar? (2 marks) l. XE.com allows you to see current exchange rates for gold ounces (type \"gold\" into the From or To box). (4 marks, 1 each) i. What is 1 ounce of gold worth in Canadian dollars? ii. In US dollars? iii. What does this imply is the exchange rate between Canadian dollars and US dollars? iv. Is this the same as your answer to part a? m. If you saw that the US dollar price of gold was one dollar less than the price you quoted in b.ii., how could you use that information to make an arbitrage profit? To get full marks, you have to show a full \"round turn.\" That is, you need to start and end with the same currency to show the amount of your profit. (4 marks) 7.2 (6 marks) a. Complete the following table using XE.com or a similar foreign-currency quote website. In each cell, record the number of units of the currency stated in the column heading that you could buy with one unit of the currency shown at the start of the row. For example, if you sold US$1, how many European Euros could you buy? Enter that amount in the third column, second row. Continue until you have completed all sections of the table. sell/buy US $1 Euros 1 US $1 Euros 1 1 How many Euros could US$1 buy? How many US$ could 1 buy? 1 Canadian $1 Japanese 1 1 Japanese 1 FNCE/ECON 300 v2 Canadian $1 1 9 June 2019 Lesson 8: Valuation of Known Cash Flows: Bonds 8.1 (4 marks) a. Look up the U.S. Treasury yield curve online. (3 marks, 1/2 mark each) i. What is the promised yield for a one-month T-bill? ii. For a six-month T-bill? iii. A 20-year T-bond? iv. A 30-year T-bond? v. What date did you look up these yields? vi. On what website did you find these yields? n. 8.2 Is this yield curve flat, rising, or inverted? (1 mark) The Law of One Price implies that financial instruments with the same risk and the same cash flows at the same time should have the same price. You are given the following table containing incomplete information on four different bonds. Assume that all these bonds have the same risk, and any coupon payments are paid annually. Note that you can find an optional webcast that shows calculations for a similar example with three strip bonds and three-year coupon bonds. See About FNCE/ECON 300: Optional Webcasts: \"Law of One Price\" or link from the Lesson 8 Reading and Learning Objectives. (20 marks total) Bond # 1 1-year strip bond Purchase price ($xxxx.xx) 2 2-year strip bond 3 4 2-year 6% coupon bond 2-year 7% coupon bond -950.00 Time 1 cash flow +1000.00 0 +60.00 +70.00 Time 2 cash flow 0 +1000.00 +1060.00 +1070.00 Yield to maturity (xx.xx%) 5.50% a. What is the yield to maturity on Bond #1? FNCE/ECON 300 v2 10 (2 marks) June 2019 b. What is the price of Bond #3? c. (2 marks) You are considering two investments from the bonds listed in the table. Portfolio 1: 60 units of Bond #1 + 1060 units of Bond #2 Portfolio 2: 1000 units of Bond #3. Show that the future cash flows from these two portfolios would be identical, in amount and timing. (2 marks) d. Based on the information in the given table, i. What would it cost to buy 1000 units of Bond #3? (1 mark) ii. What would it cost to buy 60 units of Bond #1? (1 mark) iii. From part c. above and your answers in part d.i and ii, infer the value of 1060 units of Bond #2. (2 marks) iv. What is the value of one unit of Bond #2? v. (1 mark) What is the implied yield of Bond #2? (2 marks) e. How many units of Bond #1 and #2 would you need to replicate the future cash flows of 1000 units of Bond #4? (2 marks) f. Using your answer to part e above, determine the following i. What's the value of 1000 units of Bond #4? (2 marks) ii. What's the yield of Bond 4? (2 marks) g. Fill in the missing information in the given table: Bond # 1 1-year strip bond Purchase price ($xxxx.xx) 2 2-year strip bond (1 mark) 3 4 2-year 6% coupon bond 2-year 7% coupon bond -950.00 Time 1 cash flow +1000.00 0 +60.00 +70.00 Time 2 cash flow 0 +1000.00 +1060.00 +1070.00 Yield to maturity (xx.xx%) FNCE/ECON 300 v2 5.50% 11 June 2019 8.3 Assume that you are thinking of buying a default-free bond. Specifically, you're thinking of buying a bond issued by Risklessco, a company that is considered default-free by all major bond rating firms. You will select one of the following three bonds, which are identical except for the special features listed. (8 marks) Bon d Face value Maturity Coupon rate (paid annually) Yield to maturity* A 1000 20 years 5.5% 5% B 1000 20 years 5.5% 5.5% Callable C 1000 20 years 5.5% 3.5% Callable and Convertible into Risklessco Stock Price Special features ? None Par ? * Yield to maturity represents the market's required rate of return. It is calculated using only stated coupon payments and face value, without regard for the special features. a. Bond B is considered identical to Bond A except for the callability provision. (4 marks, 1 each) i. What would be the price of Bond A? ii. What is the implied value of the callability provision? iii. Who does the callability provision benefit: the issuer or the purchaser? iv. Is this consistent with the price you calculated for Bond A relative to the price of Bond B? Briefly explain. o. Bond C is considered identical to bond B except for the conversion privilege. (4 marks, 1 each) i. What would be the price of Bond C? ii. What is the implied value of the conversion privilege? iii. Does the conversion privilege benefit the issuer or the purchaser of the bond? iv. Is this consistent with the price you calculated for Bond C relative to the price of Bond B? Briefly explain. Once you have completed all the questions for Lessons 5 to 8, submit your assignment for grading via the designated assignment drop box. FNCE/ECON 300 v2 12 June 2019