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