Amortization Schedules This project requires you to create an amortization schedule for several types of loans, including a fully amortizing constant payment mortgage (CPM) loan, partially amortizing CPM loan, interest only CPM loan, and constant amortizing mortgage (CAM) loan In your report, compare the amortization schedules and describe how are they different and or similar Consider a $50,000 loan made at a 6 percent interest rate (annual rate compounded monthly) for 5 years Be sure to show calculations and reference cells where needed (i e do not simply type in values but reference other cells to compute the calculations) Part 1 Fully Amortizing CPM Loan Calculate the constant monthly mortgage payment on this loan, assuming it is to be fully amortized at the end of 5 years Use the excel PMT function to calculate the monthly payment Fill in the amortization schedule (11 Points) Part 2 Partially Amortizing CPM Loan Calculate the constant monthly mortgage payment on this loan, assuming it is to be partially amortized at the end of 5 years with a balance of $10,000 Use the excel PMT function to calculate the monthly payment Fill in the amortization schedule (11 Points) Part 3 Interest Only CPM Loan Calculate the constant monthly mortgage payment on this loan, assuming it is an interest only loan Use the excel PMT function to calculate the monthly payment Fill in the amortization schedule (11 Points) Part 4 CAM Loan Calculate the constant monthly amortization amount on this loan, assuming it is an CAM loan Fill in the amortization schedule (11 points) Part 1 Fully Amortizing CPM Loan Al Loan Number Number periods Modic rate Montpament 20 29 3 12 NEDARBU NO Morehe 126 an 19 116 f w M a ENT ww HA it H la T RA Part 3 Interest Only CPM Lean jounds 12 B 201 XOO 19 Anonsasion Thomann Ending Loan Balane Ending man Balance EVE M Part 2 Partially Amazing CPM Lom EdanceFV) Part 4 CAM Loan Anonication IN May HE F 201 M 162 293 P T 10 17 Amunaton Monti, PamardErdegl com Barce

The Answer is in the image, click to view ...

Question: Amortization Schedules This project requires you to create an amortization schedule for several types of loans, including a fully amortizing constant payment mortgage (CPM) loan,

Amortization Schedules

This project requires you to create an amortization schedule for several types of loans, including a fully amortizing constant payment mortgage (CPM) loan, partially amortizing CPM loan, interest only CPM loan, and constant amortizing mortgage (CAM) loan. In your report, compare the amortization schedules and describe how are they different and/or similar.

Consider a $50,000 loan made at a 6 percent interest rate (annual rate compounded monthly) for 5 years. Be sure to show calculations and reference cells where needed (i.e. do not simply type in values but reference other cells to compute the calculations).

Part 1: Fully Amortizing CPM Loan

Calculate the constant monthly mortgage payment on this loan, assuming it is to be fully amortized at the end of 5 years. Use the excel PMT function to calculate the monthly payment. Fill in the amortization schedule. (11 Points)

Part 2: Partially Amortizing CPM Loan

Calculate the constant monthly mortgage payment on this loan, assuming it is to be partially amortized at the end of 5 years with a balance of $10,000. Use the excel PMT function to calculate the monthly payment. Fill in the amortization schedule. (11 Points)

Part 3: Interest Only CPM Loan

Calculate the constant monthly mortgage payment on this loan, assuming it is an interest only loan. Use the excel PMT function to calculate the monthly payment. Fill in the amortization schedule. (11 Points)

Part 4: CAM Loan

Calculate the constant monthly amortization amount on this loan, assuming it is an CAM loan. Fill in the amortization schedule. (11 points)

Amortization Schedules This project requires you to create an amortization schedule for

Part 1 Fully Amortizing CPM Loan Al Loan Number Number periods Modic rate Montpament 20 29 3 12 NEDARBU NO Morehe 126 an 19: 116 f w M a ENT ww HA it H la T RA Part 3: Interest Only CPM Lean jounds 12 | B 201 XOO 19 Anonsasion Thomann |Ending Loan-Balane Ending man Balance EVE M Part 2: Partially Amazing CPM Lom EdanceFV) Part 4: CAM Loan Anonication IN May HE F 201 M 162 293 P T 10 17 Amunaton Monti, PamardErdegl.com.Barce

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Superior Markets, Inc., operates three stores in a large metropolitan area. A segmented absorption costing income statement for the company for the last quarter is given below: The North Store has...

This project requires you to create an amortization schedule for two types of loans, a fully amortizing constant payment mortgage (CPM) loan, and a constant amortizing (CAM) loan. In your report,...

all parts please Amortization Schedules This project requires you to create an amortization schedule for two types of loans, a fully amortizing constant payment mortgage (CPM) loan and a constant...

Amortization Schedules This project requires you to create an amortization schedule for two types of loans, a fully amortizing constant payment mortgage (CPM) loan and a constant amortizing (CAM)...

Amortization Schedules This project requires you to elaborate an amortization schedule for two types of loans, a fully amortizing constant payment mortgage (CPM) loan and a constant amortizing (CAM)...

Question number 17, 18, 19, 20 of Real Exzxstate Finance Test bank as attached CHAPTER 4 Fixed Interest Rate Mortgage Loans TRUE/FALSE 1. Inflation makes very little difference to lenders of and...

Define a Mission Statement to include minimum financial thresholds (e.g., EIRR, EMx. etc.) What stage is this building in its financial and physical lifecycle? What risks should investors be aware of...

General Instructions for parts 1-4: Your complete assignment should read and look like a professional report For each part, you are required to create an "input box" and an "output box" area. The...

1. P repare journal entries to record the following hypothetical 2006 events: a. A customer deposits $50,000 in a WaMu sav ings account on 1/1/2006 . b. WaMu pays 1% (annual) interest on that deposit...

I need your help in this. today. will be your client. For exclusive use Florida International University, 2015 REVISED SEPTEMBER 6, 2013 CRAIG FURFINE KEL757 The Return of the Loan: Commercial...

I need an expert for this. please check info for details. For exclusive use Florida International University, 2015 REVISED SEPTEMBER 6, 2013 CRAIG FURFINE KEL757 The Return of the Loan: Commercial...

The table below lists everyone enrolled in the course in a college in Nothern Liberia and their major. Student Major Melissa A. Environmental Science and Policy Milana B. International Development...

Which two principal financial statements explain the difference between two balance sheet dates? Describe how these financial statements explain the difference between two balance sheet dates.

2 3 . Physical controls to safeguard assets do not include a . cashier department supervisors. b . vaults. c . employee identification badges. d . cash registers.

Suppose a five - year, $ 1 , 0 0 0 bond with annual coupons has a price of $ 9 0 2 . 1 8 and a yield to maturity of 6 . 2 % . What is the bond's coupon rate? The bond's coupon rate is % . ( Round to...