FREE Trial

Your company took out an amortizing loan with the following terms: A 1 Amount 2 Term (years) 10 3...

This problem has been solved!
Do you need an answer to a question different from the above? Ask your question!

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?

Expert Answer:

Answer rating: 100% (QA)

the total outstanding balance at the end of year two is 7593 41 BEGINNING SCHEDULE View the full answer


answer-question
Related Book For  answer-question
Income Tax Fundamentals 2013

Income Tax Fundamentals 2013

ISBN: 9781285586618

31st Edition

Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill

See More Books
View Solution
Create a free account to access the answer
Cannot find your solution?
Post a FREE question now and get an answer within minutes. * Average response time.
Posted Date: September 18, 2023 01:36:58
See More Questions

Students also viewed these finance questions

Q:
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...
A:
Ans a Uploaded through Photo Ans b For given time t 2 years The option will be in the money for any......
Q:
Determine a house of quality for a ballpoint pen. In the house of quality, fill in three customer requirements. Determine one technical requirement for each customer requirement and fill it in....
A:
Many answers are possible One is Technical Requireme......
Q:
You are given the following information: a. Calculate the 10-day moving-average NH-NL indicator. b. If there are 120 new highs and 20 new lows today, what is the new 10-day movingaverage NH-NL...
A:
a Day New Highs New Lows NH NL Indicator 1 117 22 95 2 95 34 61 3 8......
Q:
Johnson Marine manufactures marine radios in three models-the 1600 model for the small boat enthusiast who will not venture far from shore, and the 2400 and 3600 models for the those with the need...
A:
1 First we find the total number of labor hours and the volume based overhead rate Total labor hours 3 x 10 000 4 x 4 000 5 x 1 000 51 000 Overhead Ra......
Q:
(a) Work the Bermuda option Problem 5 of Chapter 4 assuming prices follow a jump diffusion with normal sized jumps. Be sure to report your jump parameters. (b) Repeat (a) using lognormal sized jumps....
A:
Click to View...
Q:
The balance sheet of Rybowiaks Building Supplies on June 30, Year 12, appears nearby. RYBOWIAKS BUILDING SUPPLIES Balance Sheet June 30, Year 12 Assets Cash . . . . . . . . . . . . . . . . . . . . ....
A:
a 1 Accounts Receivable 85 000 Sales Revenue 85 000 Assets Liabilities Shareholders Equity Class 85 000 85 000 IncSt RE Sales of merchandise on account 2 Merchandise Inventory 46 300 Accounts Payable......
Q:
A RM1000 face-value Bond A has the following information : YTM ( continuous compounding) : 10.0% Coupon rate ( p.a ) : 7.5% Maturity period ( year) : 29 Expected change in YTM next year : -1%...
A:
Certainly here are the calculations for the given bond information in Excel format a Compute the price for this bond To compute the price of the bond you can use the following formula Price C YTM 1 1......
Q:
8.a A Spartan missile and a Trojan missle are both flying at the s ame constant altitude. At time t, the Spartan missile is at the point: Clear[spartan, t] spartan[t_] = {16.1-7t+ t, 13 t - 2 t}...
A:
Click to View...
Q:
Predict the MAJOR product by proposing a plausible step by step mechanism. Indicate stereochemistry when applicable. H3O* Et. OH
A:
Click to View...
Q:
1. Respond to what Lafeisha said. Hi everyone! I'm Laf, short for Lafeisha, and I'm thrilled to be part of this course with all of you. I hail from the picturesque island of St. Vincent and the...
A:
Response to Lafeisha Hi Lafeisha It s so nice to meet you I m excited to learn more about St Vincent......
Q:
Please write the PySpark code to find the following: Count the employees whose Total Working Years are greater than 20. Hint: Find EmployeeNumber, EducationField, JobRole for all the employees whose...
A:
You can use PySpark to achieve this by filtering the DataFram......
Q:
deployment plan for implementing a high-availability cluster for the entire environment. which focused on data-storage back-up and recovery, this new request is to extend the high-availability...
A:
1 Introduction This document outlines the deployment plan for implementing a high availability cluster for the entire environment The focus of this pl......
Q:
Consider a rail gun. A small rocket (10 kg) is launched by a rail gun of length 10 m. The rails have inductance per length of 4H/m. The circuit has 10kV through a restance of 100. V = 10 kV + d = 10...
A:
To calculate the force on the rocket and its exit velocity when launched from a railgun we can use the principles of electromagnetism and Newton s law......
Q:
The following account appears in the record of the Kart Company MACHINERY Date 2003 Jan. 2 Dec. 31 2004 Jan 2 Dec. 31 2005 Jan. 2 Aug 2 2 Dec. 31 2006 Jan. 2 2 Dec. 31 2007 Jan 2 Dec. 31 Explanation...
A:
SOLUTION To prepare the work papers and necessary audit adjustments for the Machinery account we need to calculate the correct balances for each year and make the appropriate adjustments Here are the......
Q:
Visit Lenovos website at lenovo.com, and review some of the latest developments. In particular, pay close attention to its product line and international expansion. Using the country/language tab in...
A:
Lenovo Inc Lenovo is a household name in the manufacture of computer hardware and electronics The company headquarters is in Beijing china However the company has various branches in located in variou......
Q:
Proposals have been made to ?sail? spacecraft to the outer solar system using the pressure of sunlight, or even to propel interstellar spacecraft with high-powered, Earth-based lasers. Sailing...
A:
c 5 m s2 Solution The acceleration of the sailing spacecraft can be calculated using......
Q:
Russell (age 50) and Linda (age 45) Long have brought you the following information regarding their income and expenses for the current year. Russell owns and operates a landscaping business called...
A:
The solutions presented here show 2012 tax calculations on 2011 forms and schedules 1040 For the year Jan 1 Dec 31 2012 or other tax your beginning Your first name and initial If a joint raturn spouse......
Q:
Scott Butterfield is self-employed as a CPA. He uses the cash method of accounting, and his Social Security number is 644-47-7833. His principal business code is 541211. Scott's CPA practice is...
A:
SCHEDULE C Form 1040 Department of the Treasury Internal Revenue Service 90 Name of proprietor A C E F G H I 2 3 4 5 Part I Income 1 8 9 10 11 12 13 14 17 6 7 Part II Expenses 28 29 288 30 Scott Batte......
Q:
Leslie is a single taxpayer who is under age 65 and in good health. For 2012, she has a salary of $23,000 and itemized deductions of $1,000. Leslie is entitled to one exemption on her tax return. a....
A:
a 23 000 b 5 950 the gr......
Islamic Finance And Recent Developments 1st Edition - ISBN: 6258494064 - Free Book