Use excel and answer the question. Please include step-by-step instructions of excel in explanation

Data and Info: https://www.dropbox.com/scl/fi/vtm3hnoojw9jhiqphqxyb/Template.xlsx?dl=0&rlkey=rfj75945k9c2jn9z4af5m7lrr "

1. Build an Excel model of the value of Holmes Truck Rental to a prospective buyer. Recall that the net present value of a stream of future payments is a "weighted sum" in which each year's payment is "discounted" by multiplying it by a discount factor = , where i is the discount rate and t is the number of years between the present date and the payment date.

2. Use a Data Table to find the initial truck rental price that achieves the highest net present value for an investor who intends to sell the firm in three years.

3. If the 9% per year growth in the truck rental rate were to continue beyond year three, together with all other assumptions about taxes, selling prices, etc., would a prospective buyer prefer to sell after three years or to continue operating the firm? Is there a fairly simple way to modify your spreadsheet to address this question directly? To be specific, try extending your model out to measure the value at the end of years four and five.

4. Under what conditions concerning the growth in the truck rental rate is sale at the end of year three an optimal strategy for a prospective buyer (holding other assumptions unchanged)?