Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. finance
  3. aloon of $430,000 is amortized over 30 years with

Aloon of $430,000 is amortized over 30 years with payments at the end of each...

50.1K

Verified Solution

Question

Finance

image
Aloon of $430,000 is amortized over 30 years with payments at the end of each month and an interest rate of 7.5%, compounded monthly. Use Excel to create an amortization table showing, for each of the 360 payments, the beginning balance, the interest owed, the principal, the payment amount, and the ending balance Answer the following, rounding to the nearest penny. a) Find the amount of each payment. $300682 b) Find the total amount of interest paid during the first 15 payments. 54009730 c) Find the total amount of interest paid over the life of the loans 652384.06 dy Find the total of all payments made over 30 years, 52164768.12 x Suppose that payment number 5 is skipped and the interest owed for month 5 is added to the balance. Payments then resume as usual for the remainder of the 30 years e) Find the balance owing at the end of month 5. 42638432 Find the balance remaining after the 360th payment. $290795

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

"Distributions to Shareholders" Please respond to the following: * From the e-Activity, contrast the differences between...

Biology
1.2K views

What are the two different mechanisms where someone could be born with down syndrome? detail is...

Basic Math
1.2K views

suppose we take a die with 3 on three sides 2 on two sides and...

Biology
1.2K views

Physicians take a sample of smokers and nonsmokers and record the time it takes them...

Physics
1.2K views

I Select the best answer for each of the following questions 1 Atom is made...

Physics
1.2K views

The two ends of a rod of length x and a uniform cross sectional area...

Basic Math
1.2K views

Journalizing Installment NotesOn the first day of the fiscal year, a company issues $71,000, 11%,...

Accounting
1.2K views

Retained earnings represents: a. cash that is available for dividends. b. the total net income...

Accounting
1.2K views

Activity Activity Cost Annual quantity of the driver Process Receivables $30,000 15,000 invoices Process Payables...

Accounting
1.2K views

Warrants exercisable at $22 each to obtain 80,000 shares of common stock were outstanding during...

Finance
1.2K views

The Fl Corporation's dividends per share are expected to grow indefinitely by 6% per year....

Accounting
1.2K views

The highest strength of association is reflected by which of the following correlation coefficients? ...