On October 1, 2014 Northstar Corp. borrowed $780,000 by signing a four-year installment note bearing interest...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
On October 1, 2014 Northstar Corp. borrowed $780,000 by signing a four-year installment note bearing interest at 9% Complete the installment note amortization schedule for this note assuming each payment requires equal total payments. Use the built-in PV functions for these calculations. Enter PV(n;) in a value box to calculate the present value of $1 over n compounding periods with a periodic rate of Similarly, use PVA(n;) to calculate the present value of an annuity. E.g., the present value of $1,000 with a periodic rate of 3% and 2 compounding periods can be entered as 1000 PV(2:3). To use the built-in PV functions to calculate the payment, the formula is Principal balance + PVA(n), where n= the number of payments and the interest rate. For example if $10,000 is borrowed by signing a four-year, 5% installment note. The note requires four equal payments of accrued interest and principal. Each of the four equal payments is calculated by entering the following in the value box: 10000/PVA(4:5), which equals payments of $2,820. Equal Total Payments Table Perod Ending Beginning Balance Periodic Interest Expense Reduction of Notes Payable Total Notes Payment Ending Balance September 30, 2015 September 30, 2016 September 30, 2017 September 30, 2018 Total On October 1, 2014 Northstar Corp. borrowed $780,000 by signing a four-year installment note bearing interest at 9% Complete the installment note amortization schedule for this note assuming each payment requires equal total payments. Use the built-in PV functions for these calculations. Enter PV(n;) in a value box to calculate the present value of $1 over n compounding periods with a periodic rate of Similarly, use PVA(n;) to calculate the present value of an annuity. E.g., the present value of $1,000 with a periodic rate of 3% and 2 compounding periods can be entered as 1000 PV(2:3). To use the built-in PV functions to calculate the payment, the formula is Principal balance + PVA(n), where n= the number of payments and the interest rate. For example if $10,000 is borrowed by signing a four-year, 5% installment note. The note requires four equal payments of accrued interest and principal. Each of the four equal payments is calculated by entering the following in the value box: 10000/PVA(4:5), which equals payments of $2,820. Equal Total Payments Table Perod Ending Beginning Balance Periodic Interest Expense Reduction of Notes Payable Total Notes Payment Ending Balance September 30, 2015 September 30, 2016 September 30, 2017 September 30, 2018 Total
Expert Answer:
Answer rating: 100% (QA)
Amount Borrowed 780000 Interest Rate 900 Number of Payment... View the full answer
Related Book For
Fundamental Accounting Principles Volume II
ISBN: 978-1259066511
14th Canadian Edition
Authors: Larson Kermit, Jensen Tilly
Posted Date:
Students also viewed these accounting questions
-
On September 1, 2014 Benson Inc. borrowed $756,000 by signing a four-year installment note bearing interest at 9%. Complete the installment note amortization schedule for this note assuming each...
-
On November 30, 2014, Calibaut Ltd. borrowed $100,000 from a bank by signing a four-year installment note bearing interest at 12%. The terms of the note require equal payments each year on November...
-
On May 31, 2014, Iceflow Technologies Inc. borrowed $400,000 from a bank by signing a four-year installment note bearing interest at 14%. The terms of the note require equal semi-annual payments each...
-
In Exercises 1114, graph each equation in a rectangular coordinate system. If two functions are indicated, graph both in the same system. Then use your graphs to identify each relations domain and...
-
What is a sole proprietorship? Name at least one advantage and disadvantage.
-
Consider babies born in the "normal" range of 37-43 weeks gestational age. Extensive data supports the assumption that for such babies born in the United States, birth weight is normally distributed...
-
Use the working papers from On Your Own 18-2. A comparative balance sheet and forms for analyzing changes in long-term assets, long-term liabilities, and stockholders' equity are provided in the...
-
1. Using the data in E, prepare a cost of production summary for the month ended January 31, 2016. In E, Chavez Concrete Inc. has two production departments. Blending had 1,000 units in process at...
-
Comparative balance sheet accounts of Pearl Inc. are presented below. Pearl Inc. Comparative Balance Sheet Accounts As of December 31, 2025 and 2024 December 31 2025 2024 Debit Accounts Cash $42,300...
-
The Lead-Tin phase diagram: a) Show the eutectic three phase reaction on this phase diagram. b) A Pb-45% Sn alloy is cooled from 300C to 100C. What phases are present for this alloy at this...
-
Determine C(z) of the following open system shown in Figure 1. R(s) G(s) A(s) Figure 1 Open system T A'(s) G(s) C(s)
-
Can we go into more depth (please keep my info private)- Main Research Question: How does legalizing recreational drugs affect crime rates in Canada? Sub-questions: Did any changes occur in the rates...
-
The Berjaya Manufacturing Company (BMC) produces an industrial chemical product. At the beginning of the year, BMC had the following standard costing sheet: Direct materials (10 kg at RM1.60) Direct...
-
1. In the political spin industry, firms face a fixed cost of entry of $3,000. These firms sell Beautiful Statements on the current political situation. Beautiful Statements can be produced at zero...
-
One of the important concepts we are learning this week is PPP (Purchasing Power Parity). The Big Mac Index is a fun idea demonstrating the PPP using just one good, the McDonalds's big mac. Pick a...
-
Current debates about ideas to revive the economy generally fall into alignment with either classical or Keynesian economic theory. Some suggest that growing U.S. debt is a strong incentive for tax...
-
5. (32 points) The table below describes the color distribution of plain M&M's candies produced at the Cleveland, Tennessee factory as of 2017 (source here). Suppose all the M&M's referenced in this...
-
Reconsider Prob. 1474. In order to drain the tank faster, a pump is installed near the tank exit as in Fig. P1475. Determine how much pump power input is necessary to establish an average water...
-
The following list of items might appear as liabilities on the balance sheet of a company that has a two-month operating cycle. Identify the proper classification of each item. In the space beside...
-
Using the information from the alphabetized post-closing trial balance below, prepare a classified balance sheet for Ialta Industries Inc. as at October 31, 2014. Be sure to use proper form,...
-
Using the numbers to represent each section of a comprehensive income statement, identify where each of items (a) through (k) should be reported: 1. Continuing operations 2. Discontinued operations...
-
A reservoir at vertex 1 in the diagram below is to supply water to several pumping stations. The edge weights are costs of laying pipe from one station to another. How should the pipe be laid so that...
-
Identify which internal control concept is being violated and explain how this may cause an opportunity for fraud to occur within a business: 1. The supervisor for the purchasing department has not...
-
All of the following are typically included in the cash and cash equivalents account except: a. Cash b. Marketable securities c. Money market funds d. 30-day U.S. Treasury bills
Study smarter with the SolutionInn App