Lisa's Lt Question Capital Budgeting using an Excel Spreadsheet Your good friend Lisa (she/her) lives in Vancouver and recently saw an advertisement for Lyft. He has approached you to get your opinion as he knows you are an aspiring accounting student at TRU. Lisa does not currently own a vehicle and is considering purchasing a new all electric vehicle as she has heard they require less maintenance and are environmentally friendly. Also, he just relocated to a new condo building that is equipped with a charging station available for residents. Lisa has decided to purchase a new 2022 Ford Mustang Mach-EC\") AWD Select. She believes that having the All-Wheel Drive (AWD) system will allow her to take passengers to the local mountain resorts and as it is a fully electric vehicle will stand out amongst users over other available rides. Lisa has the choice of two vehicles. The first one is located in Edmonton, Alberta at Koch Ford while the second is nearby in Maple Ridge, BC which is accessible by public transit. Both are available for immediate delivery, however, Lisa would have to travel to Edmonton and drive it to Vancouver for a cost of S500. Lisa has told you she prefers the color of the Edmonton vehicle. Lisa has placed a hold on each of these vehicles and has received the following purchase quotes from each of the Ford dealerships: #4448332 #A48648 Koch Ford West Coast Ford AWD Select AWD Select Base price 54,995.00 $ 54,995.00 Options 5,540.00 4,390.00 Shipping 2,095.00 2,095.00 TaxableAmount S 62,630.00 5 61,480.00 7.0% PST 4,384.10 4,303.60 5.0% GST 3,131.50 3,074.00 Total 70,145.60 $ 68,857.60 Lisa estimates her average marginal tax rate is 22% and currently earns 9% per year on her other investments. You note from your tax studies that Capital Cost Allowance ("CCA") using Class 16 at 40% would apply. Lisa believes that a salvage value of $35,000 will be realized at the end of the fourth year. She estimates that she can earn an average of $960 in revenues per week that will be offset by average operating costs of $2,980 per month for charging fees, maintaining the correct ICBC insurance and maintenance expenses. Lisa recently reviewed the BC Hydro website htt s: electricvehiclesbch clro.com bu in EV-models- in-BC and found that there were numerous Battery Electric SUV models available that are eligible for of up to $9,000 EV rebates from various levels of government. Lisa would like you to review these EV rebates and explain to her how you believe they would impact her upcoming purchase. Required submit your response via the Assignment #2 moodle dropbox for the following: 1) Using a new Excel spreadsheet (not handwritten), on the first tab compute the net present value of for each of these two (2) potential investments. Show and explain all relevant details of your calculations so that Lisa can see each step INCLUDING the impact of any applicable EV rebates from your review ofthe BC Hydro website. (14 marks)