Your company took out an amortizing loan with the following terms: A 1 Amount 2 Term...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Your company took out an amortizing loan with the following terms: A 1 Amount 2 Term (years) 10 3 Interest rate 6% B 9,000 Create an amortization table in Excel. What is the outstanding balance at the end of the second year? Your company took out an amortizing loan with the following terms: A 1 Amount 2 Term (years) 10 3 Interest rate 6% B 9,000 Create an amortization table in Excel. What is the outstanding balance at the end of the second year?
Expert Answer:
Answer rating: 100% (QA)
the total outstanding balance at the end of year two is 759341 BEGIN... View the full answer
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these finance questions
-
Prove that the following language is undecidable. L= {(M)|M is a TM and accepts at least one string of the form 1*0*1*} To do so: 1. Describe a reduction from ATM to L 2. Prove correctness of your...
-
For a project manager working in the federal government, creating an Independent Government Cost Estimate (IGCE) is crucial to defining and developing successful acquisitions. What is the primary...
-
KYC's stock price can go up by 15 percent every year, or down by 10 percent. Both outcomes are equally likely. The risk free rate is 5 percent, and the current stock price of KYC is 100. (a) Price a...
-
Refer to the Webers Data Set above. 1. Compute the direct materials efficiency variance for onion, mustard, and ketchup. 2. As a manager, what would you learn from the variances and supporting data?...
-
Determine by direct integration the moment of inertia of the shaded area with respect to the x axis. be
-
Explain Jonathan Edwards "new Light theology"
-
Explain precondition and post-condition by examples.
-
Consider the business event processing activity, entering a customers order. Identify the key business event data ( who, what, where, and when) you would want to capture.
-
Accounting for Fair Value Hedge: Put Option PierTwo purchased at par 100 $100 5% bonds of Supplier Inc. on January 1. To avoid exposure to fluctuations in the fair value of Supplier Inc. bonds,...
-
Erica and Bob participate in a friendly Hackathon that allows each to solve one question a day out of the three offered. There will be one easy, one medium and one hard question, with points awarded...
-
5. Liquid methanol (CH3OH) is to be burned with 100% excess air. The engineer designing the furnace must calculate the highest temperature (in C) that the furnace walls will have to withstand so that...
-
Show the journal entries needed to correct the following errors: (a) Purchases 1,410 on credit from A. Ray had been entered in B. Roys account. (b) A cheque of 94 paid for printing had been entered...
-
R. Sheldon presents you with the trading account set out above.(Authors note) He always calculates his selling price by adding 331 /3% of cost on to the cost price. (a) If he has adhered strictly to...
-
On January 1, 20Y5, Dr. Marcie Cousins established Health-Wise Medical, a medical practice organized as a corporation. The following conversation occurred the following August between Dr. Cousins and...
-
Media Skills: Email The following email message contains numerous errors related to what youve learned about planning and writing business messages. SUBJECT: Compliance with new break procedure Some...
-
Media Skills: Social Networking Joining an ongoing social media conversation, such as a comment thread on Facebook, requires a delicate touch if you work for a company that has a commercial interest...
-
Assume that the standard cost to make one finished unit includes 1 hour of direct labor at $4 per hour. During march,11,000 direct labor hour were worked,5250 units of product were manufactured and...
-
Which of the following gives the range of y = 4 - 2 -x ? (A) (- , ) (B) (- , 4) (C) [- 4, ) (D) (- , 4] (E) All reals
-
Steve Drake sells a rental house on January 1, 2012, and receives $130,000 cash and a note for $55,000 at 10 percent interest. The purchaser also assumes the mortgage on the property of $45,000....
-
In 2012, Gale and Cathy Alexander hosted an exchange student, Axel Muller, for 9 months. Axel was part of International Student Exchange Programs (a qualified organization). Axel attended tenth grade...
-
Ray and Maria Gomez have been married 3 years. They live at 1610 Quince Ave., McAllen, TX 78701. Ray works for Palm Oil Corporation and Maria works for the City of McAllen. Maria's Social Security...
-
In Fig. 1130, there is no explicit invariant that states that a Transaction cannot be linked to movements that are linked to the same account, because the structure of the model already demands is....
-
Apply the Account/Transaction pattern to the parallel financial transactions of the example shown in Figs. 1131 to 1135. As the bills may be paid forward, it may be necessary to use memo entries....
-
Look at Fig. 1119 and create a new discount strategy that gives a percentage of discount for sales with more than a certain number of products. Order | < > < > +nr: Natural = < > +date: Date...
Study smarter with the SolutionInn App