ABC, Inc. is evaluating financing options for new equipment. As part of this analysis, you will calculate loan payments, build an amortization schedule, and explore the impact of additional payments over time. This assignment will be completed using Microsoft Excel, with a focus on applying formulas and financial functions.
Instructions
Step 1: Download and Complete the Excel File
Download the provided Excel Template Download Excel Template
file to begin your work.
All work must be completed within the provided spreadsheet using Excel formulas only.
Do not hardcode any numbers (except for dates); use cell references and functions throughout.
Part 1: Base Loan Amortization
Calculate the Loan Payment
Use the PMT function in Excel based on the provided loan terms.
Build the Amortization Schedule
Create a complete schedule using formulas only.
Answer Questions
Respond to any related prompts using formulas.
Part 2: Increased Year-End Payments Scenario
ABC, Inc. expects excess operating cash each year for the next five years. They are considering increasing their December 31 payment by $30,000 annually.
Update the Amortization Schedule
Modify your existing table to reflect this extra yearly payment.
Analyze the Impact
Answer any follow-up questions using formulas.
File Naming & Submission
Save your completed file as:
Acctg326_Sec#_LoanAmortization_YourName (replace Sec# with your actual section number)
Save it as an Excel file (.xlsx).
Submit your file individually through the course platform.
Get this or a similar paper done in as fast as 4 hours, 24/7.
NB: We do not sell prewritten papers. All essays are written from scratch according to specific needs and instructions
Leave a Reply
You must be logged in to post a comment.