Accounting - Time Value of Money EXCEL assignment

profilegUesttoni
TVMProjectACFI340Spring2020Updated.xlsx
Home>Business & Finance homework help>Accounting homework help>Accounting - Time Value of Money EXCEL assignment

Cover Sheet

Your Name: Your Version Numbers:
Points Assigned Points Earned 11 AM Section Version Numbers
Basic PV Problems: Bernard Marvin 49 48 5
Scenario 1 27 0 Chin Dezzann 67 30 6
Scenario 2 27 0 Donahue Kyle 13 30 5
Scenario 3 30 0 Govoni Bryce 4 25 5
Loan Amortization 30 0 Howell Tariq 61 35 7
Bond Valuation 36 0 Jean-Louis Kevley 49 14 7
Totals 150 0 MacNeil Caila 92 41 9
Malone Dan 54 4 8
Mason Eric 54 39 7
Moore Isaac 54 3 6
Payamps Yanibel 30 14 10
Picardi David 86 47 5
Quinto EJ 58 20 8
Roy Matthew 4 42 7
Salamone Toni 50 15 8
Salvatore Alex 13 5 7
Sosa-Baez Francis 22 39 6
Wendel Elijah 9 27 8
Whiffen Gina 39 20 8
Wiper Devin 70 2 8
Young Vance 62 26 7
12:30 PM Section
Cowen Charlie 60 35 5
Delehanty Jaryd 10 9 7
Gordon Biankah 28 29 9
Hrenko Joey 35 34 10
Lama Rinzing 40 28 10
Martignetti Kendall 54 26 8
Moran Matthew 34 49 7
Pontbriand Alec 72 13 9
Sarhan Nayfa 99 17 8
6 PM Section
Arzeno Tomas 18 34 9
Beinars Gregory 17 47 8
Contois Ralph 23 30 8
Diaz Keila 56 33 8
Harding Justin 49 17 9
Li Jeff 34 9 7
Patel Hirenkumar 30 6 8
Tavares Justin 96 29 5

Basic PV Problems

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 spaces provided. Perform your calculation in the space provided for the PV. Answer the follow up questions. You must use Excel formulas to perform all calculations.
Scenario 1 Scenario 2 Scenario 3
On October 31, 2020, Trvgiic Equipment Supply Corp. an injection molding machine to a customer for $1,175,400. Trvgiic agreed go accept a three-year, zero-interest note with monthly payments of $32,650 beginning on November 30, 2020. Trvgiic Equipment Supply Corp. normally incurs interest at a rate of 7.1% and the customer incurs interest at 8.3% on loans for similar periods. On November 30, 2020, Trvgiic Equipment Supply Corp. a packaging machine to a customer for $202,800. Trvgiic agreed go accept a two-year, zero-interest note with monthly payments of $8,450 beginning on November 30, 2020. Trvgiic Equipment Supply Corp. normally incurs interest at a rate of 7.1% and the customer incurs interest at 9.5% on loans for similar periods. On April 1, 2020, Trvgiic Equipment Supply Corp. a blow-molding machine to a customer for $954,000. Trvgiic 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. Trvgiic 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.
rate nper PMT FV 0 or 1 PV rate nper PMT FV 0 or 1 PV rate nper PMT FV 0 or 1 PV
6 points 6 points 6 points
0 0 0
Determine the following amounts that Trvgiic Equipment Supply Corp. would report in its GAAP financial statements for the year ended December 31, 2020. Determine the following amounts that Trvgiic Equipment Supply Corp. would report in its GAAP financial statements for the year ended December 31, 2020. Determine the following amounts that Trvgiic Equipment Supply Corp. would report in its GAAP financial statements for the year ended December 31, 2020.
Sales Revenue 2 points 0 Sales Revenue 2 points 0 Sales Revenue 2 points 0
Interest Revenue 2 points 0 Interest Revenue 2 points 0 Interest Revenue 2 points 0
Notes Receivable @ Carrying Value 2 points 0 Notes Receivable @ Carrying Value 2 points 0 Notes Receivable @ Carrying Value 2 points 0
You must complete this amortization table using Excel formulas to support your answers above other than Sales Revenue. You must complete this amortization table using Excel formulas to support your answers above other than Sales Revenue. You must complete this amortization table using Excel formulas to support your answers above other than Sales Revenue.
Income Statement Statement of Cash Flows Amortization of Carrying Value Balance Sheet Income Statement Statement of Cash Flows Amortization of Carrying Value Balance Sheet Income Statement Statement of Cash Flows Amortization of Carrying Value Balance Sheet
Period Interest Revenue Cash Received Amortization Carrying Value 6 points 0 Period Interest Revenue Cash Received Amortization Carrying Value 6 points 0 Period Interest Revenue Cash Received Amortization Carrying Value 6 points 0
0 0 0
1 0 1
2 1 2
3
Prepare the journal entries that Trvgiic Equipment Supply Corp. would record on each of the dates given. You will not use every line. Prepare the journal entries that Trvgiic Equipment Supply Corp. would record on each of the dates given. You will not use every line. Prepare the journal entries that Trvgiic Equipment Supply Corp. would record on each of the dates given. You will not use every line.
3 points per entry = 9 points 3 points per entry = 9 points 3 points per entry = 12 points
DATE ACCOUNT NAMES DEBIT CREDIT DATE ACCOUNT NAMES DEBIT CREDIT DATE ACCOUNT NAMES DEBIT CREDIT
31-Oct 0 30-Nov 0 1-Apr 0
30-Nov 0 30-Nov 0 30-Jun 0
31-Dec 0
30-Sep 0
31-Dec 0
31-Dec 0

Loan Amortization

On July 1, 2020, Trvgiic Equipment Supply Corp. arranged an installment loan with its bank to acquired funds needed to expand its warehouse capacity. Trvgiic signed a note that required equal monthly payments of principal and interest beginning on July 31. Presented below is the other relevant information pertaining to the note.
Principal Borrowed $ 1,010,000
Interest Rate (APR) 6.00%
Term in Years 4
Enter the applicable values to be used to calculate the monthly payment into the table below. Then compute the monthly payment of principal and interest that Trvgiic Equipment Supply Corp. will be required to pay on the loan.
rate nper PV FV 0 or 1 PMT
6 points
0
Prepare the loan amortization schedule below for the entire term of the loan. Use the information in the amortization schedule to answer the following questions.
Determine the following amounts that Trvgiic Equipment Supply Corp. would report in its GAAP financial statements for the year ended December 31, 2020.
Interest Expense 2 points 0
Current Portion of Long-Term Debt 2 points 0
Long-Term Debt excluding Current Portion 2 points 0
Income Statement Statement of Cash Flows Amortization of Carrying Value Balance Sheet
Period Interest Expense Cash Paid Amortization Carrying Value 18 points 0
0

Bond Valuation

Here is information about three bonds. In the spaces provide, for each bond, compute: 1) the amount of the stated coupon payment cash flow; 2) the amount of the bond proceeds that would be received upon the issuance of each bond; and, 3) the resulting bond price quotation.
Bond � Bond � Bond �
Face Value $20,000,000 Face Value $ 15,000,000 Face Value $ 30,000,000
Stated Coupon Interest Rate 6.00% Stated Coupon Interest Rate 6.00% Stated Coupon Interest Rate 8.00%
Market Yield Rate 6.00% Market Yield Rate 6.00% Market Yield Rate 7.80%
Term in Years 20 Term in Years 25 Term in Years 20
Interest Paid Semi-Annually Interest Paid Annually Interest Paid Semi-Annually
Stated Coupon Payment 2 points 0 Stated Coupon Payment 2 points 0 Stated Coupon Payment 2 points 0
Indicate the inputs that you will use to perform your analyses in the spaces provided. Perform your calculation in the space provided for the PV. Indicate the inputs that you will use to perform your analyses in the spaces provided. Perform your calculation in the space provided for the PV. Indicate the inputs that you will use to perform your analyses in the spaces provided. Perform your calculation in the space provided for the PV.
rate nper PMT FV 0 or 1 PV rate nper PMT FV 0 or 1 PV rate nper PMT FV 0 or 1 PV
6 points 6 points 6 points
0 0 0
Bond Proceeds at Issuance 2 points 0 Bond Proceeds at Issuance 2 points 0 Bond Proceeds at Issuance 2 points 0
Bond Price Quotation 2 points 0 Bond Price Quotation 2 points 0 Bond Price Quotation 2 points 0

Version Generator

0 0 0
Loan Amortization Bond Valuation
Principal Borrowed (PV) $ 1,010,000 Bond � Bond � Bond �
Interest Rate 6.00% 0.00% 0.00% Face Value $ 20,000,000 $ 15,000,000 $ 30,000,000
Term in Years 4 0 Stated Coupon Interest Rate 6.00% 6.00% 8.00% 0.00% 0.00% 0
Payments per Year 12 Market Yield Rate 6.00% 6.00% 7.80% 0.00% 0.00%
Term in Years 20 25 20
Interest Paid Semi-Annually Annually Semi-Annually Annually