A B D E F H J K Function: PV, PMT; Formula: Add; Cell Referencing Using...

Transcribed Image Text:

A B D E F H J K Function: PV, PMT; Formula: Add; Cell Referencing Using Excel to Determine a Lease Payment with a Guaranteed Residual Value PROBLEM Cardinal Company is negotiating to lease a piece of equipment to MTBA, Inc. Cardinal wants a guarantee that the residual value of the equipment at the end of the lease. MTBA agrees to guarantee a residual value of this amount though it expects the residual value of the equipment to be less. Each payment will be made at the beginning of each year. Information concerning the lease follows. Fair value of leased equipment at commencement $ 70,000 Guaranteed residual value of the equipment Student Work Area Required: Provide input into cells shaded in yellow in this template. Input the required mathematical formulas or functions with cell references to the Problem area or work area as indicated. Use the PMT function to determine the amount of the annual rental payments Cardinal demands of MTBA. Display each answer as a positive amount. 5,000 Expected residual value 2,500 Cardinal's desired rate of return 8% Lease term in years 9 Useful life of leased equipment in years 10 329,380 Amount to be recovered through lease payments Payment amount A B D E F H J K Function: PV, PMT; Formula: Add; Cell Referencing Using Excel to Determine a Lease Payment with a Guaranteed Residual Value PROBLEM Cardinal Company is negotiating to lease a piece of equipment to MTBA, Inc. Cardinal wants a guarantee that the residual value of the equipment at the end of the lease. MTBA agrees to guarantee a residual value of this amount though it expects the residual value of the equipment to be less. Each payment will be made at the beginning of each year. Information concerning the lease follows. Fair value of leased equipment at commencement $ 70,000 Guaranteed residual value of the equipment Student Work Area Required: Provide input into cells shaded in yellow in this template. Input the required mathematical formulas or functions with cell references to the Problem area or work area as indicated. Use the PMT function to determine the amount of the annual rental payments Cardinal demands of MTBA. Display each answer as a positive amount. 5,000 Expected residual value 2,500 Cardinal's desired rate of return 8% Lease term in years 9 Useful life of leased equipment in years 10 329,380 Amount to be recovered through lease payments Payment amount