Answer BE10-6 on the third image using excel and financial calculator.

(LO 3) BE10-6 Chavez Corporation purchased a truck by issuing an $80,000, four-year, non-interest-bearing note to Equinox Inc. The market interest rate for obligations of this nature is 8%. Calculate the purchase price using any of the three methods (tables, financial calculator, or Excel). Prepare the journal entry to record the truck purchase.Brief Exercise 10-6 Tamarisk Corporation purchased a truck by issuing an $84,000, four-year, noninterest-bearing note to Equinox Inc. The market interest rate for obligations of this nature is 12%. Click here to View the factor table PRESENT VALUE OF 1. Click here to View the factor table PRESENT VALUE OF AN ANNUITY OF 1. Prepare the journal entry to record the truck purchase. (Credit account titles are automatically indented when the amount is entered. Do not indent manually. If no entry is required, select "No Entry" for the account titles and enter 0 for the amounts. Round factor values to 5 decimal places, e.g. 1.25.124 and final answers to 0 decimal places,e e.g. 5,275.) Account Titles and Explanation Debit Credit il'rucks . l _ Notes Payable I BRIEF EXERCISE 10-6 TruckS.. 58,802 Notes Payable.. 58,802 Using tables: Present value of the single payment $80,000 X .73503 $58,802.40 Using a financial calculator: PV ? Yields $58.802.39 8% N 4 PMT $0 FV $(80,000) Type 0 Using Excel: =PV(rate, nper,pmt,fv,type) The variables are as given for the financial calculator above, nper is n and rate is