Question

In: Finance

Required information [The following information applies to the questions displayed below.] NOTE: Throughout this lab, every...

Required information

[The following information applies to the questions displayed below.]

NOTE: Throughout this lab, every time a screenshot is requested, use your computer's screenshot tool, and paste each screenshot to the same Word document. Label each screenshot in accordance to what is noted in the lab. This document with all of the screenshots included should be uploaded through Connect as a Word or PDF document when you have reached the final step of the lab.

In this lab, you will:

Required:

1. Calculate the monthly payment for a 15-year and a 6-year mortgage loan.

2. Calculate the amount of interest that you’d pay for a 15-year mortgage loan and a 6-year mortgage loan.

Ask the Question: How much interest do you pay over the life of a 15-year and a 6-year mortgage?


Master the Data: There is no data file for this lab. We will make the needed calculations and input the data as we go.

To compute the mortgage payments, we’ll need to know a few things:

  1. The size of the mortgage loan
  2. The interest rate
  3. The length of the loan (number of months)

Let’s suppose you would like to buy a home for $250,000. But like most U.S. citizens, you don’t have enough cash on hand to pay for the full house. But we’re in luck! Signature Bank has agreed to offer you a 30-year mortgage loan, but requires that you pay 20 percent down ($50,000 = 20% of $250,000) to qualify for their mortgage loan of $200,000 in this way:

$250,000 Cost of home
50,000 Required 20% down payment ($50,000 = 20% of $250,000) (The
cash you need to have available to pay when closing on the home)
$200,000 Amount of the bank loan

Software needed

  • Excel
  • Screen capture tool (Windows: Snipping Tool; Mac: Cmd+Shift+4)

Perform the Analysis: Refer to Lab 1-3 Alternative in the text for instructions and Lab 1-3 steps for each of the lab parts.

Share the Story: Accountants need to know how much of each monthly mortgage (or bond) payment goes toward interest.

Part 1: Upload Your Files

Part 2: Assessment

Upload the Word or PDF document containing your Lab screenshots using the button below. (Zip "Lab 1-3 Alt Submission 1.jpg" & "Lab 1-3 Alt Submission 2.jpg" files and upload the same.)

  1. Take a screenshot of the top 20 lines of your 180-month amortization schedule and label it “Lab 1-3 Alt Submission 1.jpg”.
  2. Take a screenshot of the top 20 lines of your 72-month amortization schedule and label it “Lab 1-3 Alt Submission 2.jpg”.

Solutions

Expert Solution

1. Calculate Monthly payment for 15 years loan & 6 years loan.

Monthly payment (EMI) to be calculated. The following table shows the EMI calculation (Note: Interest rate is not provided. Assumed at 6%)

Answer: Monthly payment for 15 years - $1,687.71 . Monthly payment for 6 years loan - $ 3,314.58. Answer is arrived at based on the below table.

EMI calculation for 15 year loan (screenshot of top 20 lines as required is saved)-

EMI calculation for a 6 year loan -

2. Calculate interest payable on 15 year loan and 6 year loan.

Answer: Interest payable on 15 year loan - $103,788.46.

Interest payable on 6 year loan - $ 38,649.59.

jeff jeffy answered 1 year ago
Next > < Previous

Related Solutions

Required information [The following information applies to the questions displayed below.] The following are the transactions...
Required information [The following information applies to the questions displayed below.] The following are the transactions for the month of July. Units Unit Cost Unit Selling Price July 1 Beginning Inventory 45 $ 10 July 13 Purchase 225 13 July 25 Sold (100 ) $ 15 July 31 Ending Inventory 170 Calculate cost of goods available for sale and ending inventory, then sales, cost of goods sold, and gross profit, under LIFO. Assume a periodic inventory system is used. LIFO...
Required information [The following information applies to the questions displayed below.] The following are the transactions...
Required information [The following information applies to the questions displayed below.] The following are the transactions for the month of July. Units Unit Cost Unit Selling Price July 1 Beginning Inventory 54 $ 10 July 13 Purchase 270 12 July 25 Sold (100 ) $ 16 July 31 Ending Inventory 224 Calculate cost of goods available for sale and ending inventory, then sales, cost of goods sold, and gross profit, under weighted average cost. Assume a periodic inventory system is...
Required information [The following information applies to the questions displayed below.] The following information is available...
Required information [The following information applies to the questions displayed below.] The following information is available for Lock-Tite Company, which produces special-order security products and uses a job order costing system. April 30 May 31 Inventories Raw materials $ 28,000 $ 52,000 Work in process 9,000 21,000 Finished goods 61,000 33,300 Activities and information for May Raw materials purchases (paid with cash) 181,000 Factory payroll (paid with cash) 200,000 Factory overhead Indirect materials 10,000 Indirect labor 46,000 Other overhead costs...
Required information [The following information applies to the questions displayed below.] The following information is available...
Required information [The following information applies to the questions displayed below.] The following information is available for Lock-Tite Company, which produces special-order security products and uses a job order costing system. April 30 May 31 Inventories Raw materials $ 46,000 $ 55,000 Work in process 9,000 19,600 Finished goods 62,000 33,300 Activities and information for May Raw materials purchases (paid with cash) 183,000 Factory payroll (paid with cash) 250,000 Factory overhead Indirect materials 11,000 Indirect labor 57,500 Other overhead costs...
A) Required information [The following information applies to the questions displayed below.] The following information pertains...
A) Required information [The following information applies to the questions displayed below.] The following information pertains to the inventory of Parvin Company during Year 2: Jan. 1 Beginning Inventory 400 units @ $ 30 Apr. 1 Purchased 2,000 units @ $ 35 Oct. 1 Purchased 600 units @ $ 38 During Year 2, Parvin sold 2,700 units of inventory at $90 per unit and incurred $41,500 of operating expenses. Parvin currently uses the FIFO method but is considering a change...
Required information [The following information applies to the questions displayed below.] The following information was reported...
Required information [The following information applies to the questions displayed below.] The following information was reported in the December 31, 2017, financial statements of National Airways, Inc. (listed alphabetically, amounts in millions). Accounts Payable $ 4,125 Accounts Receivable 710 Aircraft Fuel Expense 10,000 Cash 3,100 Common Stock 1,285 Dividends 20 Equipment 15,930 Income Tax Expense 320 Interest Expense 260 Landing Fees Expense 4,400 Notes Payable 7,015 Repairs and Maintenance Expense 2,500 Retained Earnings (as of December 31, 2017) 8,060 Salaries...
Required information [The following information applies to the questions displayed below.] The following information is available...
Required information [The following information applies to the questions displayed below.] The following information is available to reconcile Branch Company’s book balance of cash with its bank statement cash balance as of July 31, 2017.    On July 31, the company’s Cash account has a $25,752 debit balance, but its July bank statement shows a $27,446 cash balance. Check No. 3031 for $1,260 and Check No. 3040 for $622 were outstanding on the June 30 bank reconciliation. Check No. 3040...
Required information [The following information applies to the questions displayed below.] The following information is available...
Required information [The following information applies to the questions displayed below.] The following information is available to reconcile Branch Company’s book balance of cash with its bank statement cash balance as of July 31, 2017.    On July 31, the company’s Cash account has a $24,754 debit balance, but its July bank statement shows a $26,063 cash balance. Check No. 3031 for $1,110 and Check No. 3040 for $547 were outstanding on the June 30 bank reconciliation. Check No. 3040...
Question: Required information [The following information applies to the questions displayed below.] Fo... Required information [The...
Question: Required information [The following information applies to the questions displayed below.] Fo... Required information [The following information applies to the questions displayed below.] For many years, Yelena Company manufactured a single product called a Mono-Relay. Then three years ago, the company automated a portion of its plant and at the same time introduced a second product called a Bi-Relay that has become increasingly popular. The Bi-Relay is a more complex product, requiring 1.00 hour of direct labor time per...
Required information [The following information applies to the questions displayed below.]    In 2018, the Westgate...
Required information [The following information applies to the questions displayed below.]    In 2018, the Westgate Construction Company entered into a contract to construct a road for Santa Clara County for $10,000,000. The road was completed in 2020. Information related to the contract is as follows: 2018 2019 2020 Cost incurred during the year $ 2,550,000 $ 4,250,000 $ 1,870,000 Estimated costs to complete as of year-end 5,950,000 1,700,000 0 Billings during the year 2,050,000 4,750,000 3,200,000 Cash collections during...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT