A $750,000 loan is to be repaid over 8-years. The interest rate on the loan i(4)...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
A $750,000 loan is to be repaid over 8-years. The interest rate on the loan i(4) = 6.5%. (a) Set up a repayment schedule assuming the loan is amortized with quarterly payments over the 8 years. (b) Assume the loan is paid back using the sinking fund method and assume a sinking fund can earn (4) = 4.2%. Set up a sinking fund schedule include a column for the quarterly expense and the book value. (c) Graph the outstanding balance of the amortized loan and the book value of the sinking fund loan on the same graph. A $750,000 loan is to be repaid over 8-years. The interest rate on the loan i(4) = 6.5%. (a) Set up a repayment schedule assuming the loan is amortized with quarterly payments over the 8 years. (b) Assume the loan is paid back using the sinking fund method and assume a sinking fund can earn (4) = 4.2%. Set up a sinking fund schedule include a column for the quarterly expense and the book value. (c) Graph the outstanding balance of the amortized loan and the book value of the sinking fund loan on the same graph. A $750,000 loan is to be repaid over 8-years. The interest rate on the loan i(4) = 6.5%. (a) Set up a repayment schedule assuming the loan is amortized with quarterly payments over the 8 years. (b) Assume the loan is paid back using the sinking fund method and assume a sinking fund can earn (4) = 4.2%. Set up a sinking fund schedule include a column for the quarterly expense and the book value. (c) Graph the outstanding balance of the amortized loan and the book value of the sinking fund loan on the same graph. A $750,000 loan is to be repaid over 8-years. The interest rate on the loan i(4) = 6.5%. (a) Set up a repayment schedule assuming the loan is amortized with quarterly payments over the 8 years. (b) Assume the loan is paid back using the sinking fund method and assume a sinking fund can earn (4) = 4.2%. Set up a sinking fund schedule include a column for the quarterly expense and the book value. (c) Graph the outstanding balance of the amortized loan and the book value of the sinking fund loan on the same graph.
Expert Answer:
Answer rating: 100% (QA)
Loan Repayment Schedules Heres a breakdown of the repayment schedules for both amortization and sinking fund methods a Amortized Loan Schedule Quarter ... View the full answer
Related Book For
Multinational Finance Evaluating Opportunities Costs and Risks of Operations
ISBN: 978-1118270127
5th edition
Authors: Kirt C. Butler
Posted Date:
Students also viewed these finance questions
-
This project is designed for you to have a complete understanding of what is entailed in buying a home. For most people, their home purchase is the largest financial purchase they will make in their...
-
Read ALL instructions before getting started! ABC Corporation is a new company that buys and sells office supplies. Business began on January 1, 2012. Given on the first two tabs are ABC's 12/31/12...
-
Multiple Choice Select the best answer and place it on the line next to the question number: 1. Bud Lime has $368,882 accumulated in a 401K plan. The fund is earning a low, but safe, 3% per year. Bud...
-
If a= 3 m, determine the magnitudes of P and Q required to maintain the cable in the shape shown. DI 120 kN
-
Go to the website for the Implicit Association Test. www.implicit.harvard.edu Links to an external site Take any variation of the Implicit Association Test Take a screenshot of the results of the...
-
Write a method called inOrderList that returns a list containing the sequence of values obtained from an inorder traversal of your binary tree of integers. For example, if a variable t refers to...
-
Mr. Zeman owns the mineral rights in a property in Grant County, Oklahoma. He leases the property to Force Petroleum, reserving a 1/5 royalty. Force drills a successful well and begins producing oil....
-
Coco Investments, LLC, and other investors participated in a condominium conversion project to be managed by Zamir Manager River Terrace, LLC. The participants entered into a new LLC agreement for...
-
The measures of the interior angles of a hexagon are represented by x, x-10, x+70, x + 30, 2x-45 and x + 45. The measure of the largest interior angle is. A. 80 B. 90 A. OB. D. C. 135 D. 160 E. 170
-
1 What are the main components of personal financial planning? Solve What is the purpose of a financial plan? Solve Identify some common actions taken to achieve financial goals. How does a job...
-
Cheryl wants to find the number of hours seventh-graders do homework each week. There are 297 girls and boys in seventh grade. Which is the best way for Cheryl to get a representative sample without...
-
A dam as an upstream face that is vertical and has the shape of a semicircle with a diameter of 100 m at the top. Water is up to the top of the dam. The atmosphere presses on the rear of the dam....
-
A new machine will cost $17,000 and will have an estimated salvage value of $14,000 in five years. Special tools for the new machine will cost $5,000 and will have a resale value of $2,500 at the end...
-
Assume a company had no jobs in progress at the beginning of July and no beginning inventories. It started and completed only two jobs during July-Job Y and Job Z. The company uses a plantwide...
-
(b) Consider a superclass Purchaseltem which models customer's purchases. This class has: -two private instance variables name (String) and unitPrice (double). - Overloaded constructors to initialize...
-
0.120 kg of steel pellets s = 449 J/ kg K are heated in a boiling water bath. The pellets are then added to a Styrofoam cup that contains 0.080 kg of water w = 4190 J/ kg K at room temperature 20 C ....
-
The excel file provides 20 weekly returns of 5 US fixed incomeindexes: US Investment Grade Corporate Bond Index, US CorporateHigh Yield Bond Index, US Agency Bond Index, US Government BondIndex and...
-
Teasdale Inc. manufactures and sells commercial and residential security equipment. The comparative unclassified balance sheets for December 31, 2015 and 2014 are provided below. Selected missing...
-
How is turnover in the ranks of top executives similar in China, Germany, Japan and the United States? How is it different?
-
Given S0$/ = $1.5000/ and the one-year forward rate F1$/ = $1.3500/, what is the dollar forward premium or discount (a) in basis points and (b) as a percentage of the spot rate? Based on the unbiased...
-
Gretchen Van Damme is considering buying call options on Swiss francs on the International Monetary Market of the Chicago Mercantile Exchange with a March expiration date and a strike price of...
-
Prepare a statement of estimated cash receipts and disbursements for October 2007 for the Aquarius Company, which sells one product, herbal soap, by the case. On October 1, 2007, part of the trial...
-
Computer Superstores Inc. has a strong belief in using highly decentralized management. You are the new manager of one of its small computer boutiques. You know a great deal about how to buy, how to...
-
Daphne Kite Company wants a master budget for the next three months, beginning January 1, 2008. It desires an ending minimum cash balance of $5,000 each month. Sales are forecasted at an average...
Study smarter with the SolutionInn App