Microsoft Excel Assignment 4

Microsoft Excel Assignment 4

 Follow Instructions and complete document . 

Documentation

Shelly Cashman Excel 2019 | Module 4: End of Module Project 1
Conyers Law Offices
CREATE A LOAN ANALYSIS
Author:Todd Washington
Note: Do not edit this sheet. If your name does not appear in cell B6, please download a new copy of the file from the SAM website.

Loan Payment Calculator

Loan Payment CalculatorAmortization Schedule
Date4/3/21YearBeginning BalanceEnding BalancePaid on PrincipalInterest Paid
Loan Amount$327,000.00Monthly Payment1$327,000.00$0.00$327,000.00($327,000.00)
Rate7.825%Total Interest20.000.000.00
Term10Total Cost30.000.000.00
Varying Interest Rate Schedule40.000.000.00
50.000.000.00
RateMonthly PaymentTotal InterestTotal Cost60.000.000.00
$0.00$0.00$0.0070.000.000.00
7.725%80.000.000.00
7.750%90.000.000.00
7.775%100.000.000.00
7.800%Subtotal$327,000.00($327,000.00)
7.825%
7.850%
7.875%
7.900%
7.925%
7.950%
7.975%
8.000%
8.025%
8.050%
8.075%

Principal and Interest Paid

Paid on Principal 1 2 3 4 5 6 7 8 9 10 327000 0 0 0 0 0 0 0 0 0 Interest Paid 1 2 3 4 5 6 7 8 9 10 -327000 0 0 0 0 0 0 0 0 0

Cost Estimates

Retirement Projections

Retirement Plan Projections
Plan 1Plan 2Plan 3
Return on balance7.00%6.75%7.25%
Monthly rate of return0.583%0.563%0.604%
Monthly payment-$200-$250-$175
Number of payments120120120
Future value
0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply