Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. accounting
  3. for parts 1-5. on a blank sheet in excel, create a

For parts 1-5. On a blank sheet in excel, create a loan amortization table for...

50.1K

Verified Solution

Question

Accounting

For parts 1-5. On a blank sheet in excel, create a loan amortization table for the following information. Loan Amount: 24000; Annual interest rate:0.06; Number of payments per year: 2; Loan period in years: 12. It would be super helpful if you could show me the formulas in excel! Thanks in advance!

1.) For an equal payment term loan (like a mortgage), what would be the interest-only portion of the third payment? A.) 678 B.) 660 C.) 452 D.) 720

2.)For an equal payment term loan (like a mortgage), what is the loan balance at the end of the third payment? A.) 22585 B.) 23303 C.) 21000 D.) 21845

3.) What is the EAIR for the equal payment loan? A.) .0609 B.) .0592 C.) .0644 D.) .06

4.) For an equal amortization loan (NOT like a mortgage) what is the total payment in period 3? A.) 1660 B.) 1000 C.) 1720 D.) 1417

5.) For an equal amortization loan what is the total payment in period 3? A.) 660 B.) 452 C.) 600 D.)720

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Finance
1.2K views

A project has annual depreciation of $24,700, costs of $100,700, and sales of $148,500. The applicable...

Biology
1.2K views

Did water move into the cell or out of the cell while it was surrounded by...

Accounting
1.2K views

Two accountants for the firm of Elwes and Wright are arguing about the merits of presenting...

Biology
1.2K views

What is the eventual fate of Glyceraldehyde 3 phosphate in the Calvin s cycle It...

Physics
1.2K views

A dead body was found within a closed room of a house where the temperature...

Accounting
1.2K views

Healthcare Finance problem 6.5 - need tables in book a) use an allocation table to...

Accounting
1.2K views

Problem 2 Mark and Windy are equal partners in WM Partnership. Mark's basis in the...

Accounting
1.2K views

Manufacturing costs for Davenport Company during 2018 were as follows: Note: The pre-determined overhead rate...

Accounting
1.2K views

An employee's fiduciary duties to her employer does not stretch beyond the actual employment relationship...

Accounting
1.2K views

TufStuff, Inc., sells a wide range of drums, bins, boxes, and other containers that are...

Finance
1.2K views

7. Write out a bond amortization table for a $1500 three year bond with 6%...

Accounting
1.2K views

ny is to withstand poor business conditions and to pay pa Discussion Questions 6. 1....