UAWN Analyze the three scenarios below that will require you to compute the present value of a transaction involving at future cash flows. Indicate the inputs that you will use to perform your analyses in the ation in the space provided for the PV. Answer the follow up questions. You must use Excel formulas to perform all calculations. Width: 10 Height: Automatic Automatic Gridlines Headings Cria view view Print Print Print Page Titles Setup choose Check for Updates. Q R S T U Scenario 3 On April 1, 2020, Trygiic Equipment Supply Corp. a blow-molding machine to a customer for $954,000. Trygiic agreed go accept a four-year, 3.5% interest note due quarterly. Interest payments begin on June 30 and are due on September 30, December 31, and March 31 with the entire principal due on March 31, 2024. Trvglic Equipment Supply Corp. normally incurs interest at a rate of 7.1% and the customer incurs interest at 7.8% on loans for similar periods. nper FV 6 points Determine the following amounts that Truglic Equipment Supply Corp. would report in its GAAP financial statements for the year ended December 31, 2020. Sales Revenue 2 points Interest Revenue 2 points Notes Receivable Carrying Value 2 points You must complete this amortization table using Excel formulas to support your answers above other than Sales Revenue. Statement of Cash Flows Amortization of Carrying Valu Statement Interest Revenue Cash Received Amortization Carrying Value 6 points MacBook Air Gridlines Headings view View Print Print ground Print Page 10 Height: Titles Setup ements, choose Check for Updates Automatic given. You will not use every line. 3 points per entry = 12 points DATE ACCOUNT NAMES 1 1-Apr DEBIT CREDIT 0 30-Jun 30-Sep 31-Dec MacBook Air UAWN Analyze the three scenarios below that will require you to compute the present value of a transaction involving at future cash flows. Indicate the inputs that you will use to perform your analyses in the ation in the space provided for the PV. Answer the follow up questions. You must use Excel formulas to perform all calculations. Width: 10 Height: Automatic Automatic Gridlines Headings Cria view view Print Print Print Page Titles Setup choose Check for Updates. Q R S T U Scenario 3 On April 1, 2020, Trygiic Equipment Supply Corp. a blow-molding machine to a customer for $954,000. Trygiic agreed go accept a four-year, 3.5% interest note due quarterly. Interest payments begin on June 30 and are due on September 30, December 31, and March 31 with the entire principal due on March 31, 2024. Trvglic Equipment Supply Corp. normally incurs interest at a rate of 7.1% and the customer incurs interest at 7.8% on loans for similar periods. nper FV 6 points Determine the following amounts that Truglic Equipment Supply Corp. would report in its GAAP financial statements for the year ended December 31, 2020. Sales Revenue 2 points Interest Revenue 2 points Notes Receivable Carrying Value 2 points You must complete this amortization table using Excel formulas to support your answers above other than Sales Revenue. Statement of Cash Flows Amortization of Carrying Valu Statement Interest Revenue Cash Received Amortization Carrying Value 6 points MacBook Air Gridlines Headings view View Print Print ground Print Page 10 Height: Titles Setup ements, choose Check for Updates Automatic given. You will not use every line. 3 points per entry = 12 points DATE ACCOUNT NAMES 1 1-Apr DEBIT CREDIT 0 30-Jun 30-Sep 31-Dec MacBook Air