Assignment: Loan Schedule and EMI ammortization
OVERVIEW
This project integrates quite a few components of your course. The most important thing to keep in mind, as you progress through this project, is to take one step at atime.
Do not rush through this project. After completing each step, pause, take a break, and give some thought to the task you've just completed. If necessary, refer back to the relevant lesson, assignments, and textbook chapters each step refers to. This will reinforce the learning process.
INSTRUCTIONS
In this project, you'll create a loan amortization schedule for an example mortgage loan. Imagine the mortgage is for a nonresidential real property your company has purchased. The property includes land and a building. Once you've created the amortization schedule, you can use it to prepare other financial documents. Your project is divided into sev- eral steps for you to follow. Each step includes figures that illustrate the concepts.
Step 1: Create a Loan Amortization Schedule
Step 2: Create a Depreciation Schedule
Step 3: Create a Schedule Combining Interest Expenses and Depreciation Expenses
Step 4: Convert the Interest Expense and Depreciation Expense
Step 5: Calculate the Aftertax Cash Outflows
Evaluation Criteria
Your instructor will use the following criteria to evaluate your project:
Step1: Create the loan amortization schedule forthe property.
Step2: Create the depreciation schedule.
Step3: Create the schedule thatcombinesinterest expenses and depreciation expenses.
Step4: Create a schedule that converts theinterestexpense and depreciation expense to aftertax dollars.
Step5: Create a schedule that shows the aftertaxcashout- flows.
Attachment:- Loan-Assignment.rar