6. Mr. Richards has a rich client that has come to him for advice, purchase or lease a new Porsche Carrara? The car costs $108,000 and he would finance it for 84 months at a 3.5% rate with 20% down plus 6% sales tax. The lease would be for 36 months, require $10,000 cash buy down and it would cost $1,393.08 including tax each month. The client will purchase this as a company vehicle. Leasing allows full deduction of the capital buy down and the lease payment and all other related expenses. The purchase is subject to MACSR depreciation limits and deduction of interest. More importantly, the clients company earns an ROE of 10%. Should he lease or purchase? What is the real cost of the lease each month if the company tax rate is 35%? 4 Excel: Use the standard TVM setup to determine the monthly payments for the purchasing the vehicle given the information provided. Calculate the total out of pocket expenses for both the purchase and the lease. Calculate the opportunity cost (not keeping capital in the company earning 10%) of each transaction. Calculate the cost of the lease after taxes.

Written: Briefly describe the analysis that you have performed detailing the comparison of the purchase versus lease. Explain the difference in out of pocket expenses and the opportunity cost of each. Intuitively, what would be your recommendation to purchase or lease? Describe the real cost of the lease after tax and why that is important.

7. Mr. Richards is trying to update his client presentations. He would like you to perform some future value calculations showing how great his returns are and how compounding works. He would like to show how $100,000 invested for 10, 20 and 30 years grows with his superior record of 8% annual returns. Just to underscore this he would also like the same compounding information with the historical annual market returns of 4%. Excel: Use the standard TVM setup to determine the FV value given the PV of $100,000, rate of .04 and .08 and NPR of 10, 20, 30. Set this up and then copy and change values as described for each of the additional five scenarios. Create a summary table showing the years and rates and the compound interest earned. Also, create a summary table showing the year and rates and calculate the overall growth of each FV net of the PV. Use both of these tables in the write up.

Written: Briefly describe the analysis that you have performed and explain the effect of compound interest. Describe what the growth rate of the money over, 10, 20 and 30 year spans. What is the difference in growth between the 4% and 8% rates? What do these rates say about the level of overall returns required to grow money and create wealth?