Your company took out an amortizing loan with the following terms A B 1 Amount 8,000 2 Term (years) 10 3 Interest rate 7 Attempt 1 3 for 10 pts Part 1 Create an amortization table in Excel What is the outstanding balance at the end of the second year

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Sep 10, 2024

Your company took out an amortizing loan with the following terms: A B 1 Amount 8,000 2 Term (years) 10 3 Interest rate 7% Attempt

Your company took out an amortizing loan with the following terms:

	A	B
1	Amount	8,000
2	Term (years)	10
3	Interest rate	7%

Attempt 1/3 for 10 pts.

Part 1

Create an amortization table in Excel. What is the outstanding balance at the end of the second year?

Step by Step Solution

There are 3 Steps involved in it

Step: 1

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

Step: 3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Risk Manager Handbook

Authors: Philippe Jorion, Global Association Of Risk Professionals

5th Edition

0470479612, 978-0470479612

More Books

Students also viewed these Finance questions

Question

★★★★★

The preclosing trial balance of a Special Revenue Fund of Mesa County at the end of its 20X7 fiscal year is: The Advance to Enterprise Fund plus another $15,000 of the funds net assets are related to...

Answered: 1 week ago

Question

★★★★★

Immediately prior to its termination, the ABC Partnership owned the following assets: Inside Basis FMV Cash $ 92,000 $92,000 Equipment $240,000 $100,000 Accumulated Depreciation $100,000 Capital...

Answered: 1 week ago

Question

★★★★★

=+ (b) Do the same for p = 2.

Answered: 1 week ago

Question

★★★★★

Its late Tuesday evening, and youve just received a phone call from Dennis Whiting, your boss at GE Capital. Dennis wants to know your reaction to the Argenti loan request before tomorrows loan...

Answered: 1 week ago

Question

★★★★★

wenzo Company uses a job order costing system that charges overhead to jobs on the basis of direct materials cost. At year-end, the Work in Process Inventory account shows the following Exerg Analys...

Answered: 1 week ago

Question

★★★★★

Villareal's nominal GDP increased from $189 billion to $280 billion last year. During the year, its economy experienced inflation, with its price Index increasing from 105 to 112, while the number of...

Answered: 1 week ago

Question

★★★★★

"A low-cost carrier or low-cost airline (also known as a no-frills, discount or budget carrier or airline) is an airline that offers generally low fares in exchange for eliminating many traditional...

Answered: 1 week ago

Question

★★★★★

List the attributes along which customer demand from different segments can vary that are important to supply chain management.

Answered: 1 week ago

Question

★★★★★

in quickbooks online: Sarah at the sarah's spa is looking for an employee who has been terminated but not deleted from the employee list, but she can't find the employee. What should she do to...

Answered: 1 week ago

Question

★★★★★

For each one of the costs below, explain whether the resource cost is explicit or implicit, and give the annual opportunity cost for each one. Assume the owner of the business can invest money and...

Answered: 1 week ago

Question

★★★★★

7. The following image shows incoming waves at times 0 and 2 seconds. Use this information to predict the resulting waves at times of 6 and 8 seconds. ____.__..._._._,,_.._.. wwF "a. -__. _...

Answered: 1 week ago

Question

★★★★★

(Appendices) Select a commonly used product, such as gasoline or milk, and track the prices of this product over a 20-year period by creating a line graph. Explain price increases and decreases based...

Answered: 1 week ago

Question

★★★★★

(Appendices) Search magazines, newspapers, and the Internet for advertisements. Collect or print out ads that offer the following: (a) something for nothing, (b) bonus for early reply, (c) offers of...

Answered: 1 week ago

Question

★★★★★

(Appendices) Brandon, age 32, is married and has a son, age one. Six months ago, Brandon purchased an individual health insurance policy covering the entire family. His son was recently diagnosed...

Answered: 1 week ago

Previous Question Next Question