A loan of $430,000 is amortized over 30 years with payments at the end of each...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
A loan of $430,000 is amortized over 30 years with payments at the end of each month and an interest rate of 8.9%, 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. $ b) Find the total amount of interest paid during the first 15 payments. $ c) Find the total amount of interest paid over the life of the loan. $ d) Find the total of all payments made over 30 years. $ Suppose that payment number 7 is skipped and the interest owed for month 7 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 7. $ f) Find the balance remaining after the 360th payment. $ A loan of $430,000 is amortized over 30 years with payments at the end of each month and an interest rate of 8.9%, 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. $ b) Find the total amount of interest paid during the first 15 payments. $ c) Find the total amount of interest paid over the life of the loan. $ d) Find the total of all payments made over 30 years. $ Suppose that payment number 7 is skipped and the interest owed for month 7 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 7. $ f) Find the balance remaining after the 360th payment. $
Expert Answer:
Posted Date:
Students also viewed these accounting questions
-
The author explores the dangerous world of undercover police work. Having read this chapter, do you believe this type of police work has the capability of corrupting police officers? If so why, and...
-
At the end of 2007, its first year of operations, the Swelland Company reported a pretax operating loss of $32,000 for both financial reporting and income tax purposes. At that time the company had...
-
Provide an example of how one domain of development (physical, cognitive, or emotional/social) can affect development in another domain.
-
In 1989, PepsiCo Inc. acquired three international franchise-food operationsPizza Hut, Taco Bell, and Kentucky Fried Chicken. PepsiCo paid an aggregate of \($3.4\) billion for the three businesses,...
-
Williams Company has an inexperienced accountant. During the first 2 weeks on the job, the accountant made the following errors in journalizing transactions. All entries were posted as made. 1. A...
-
The two independent cases are listed below: Sales Revenue Cost of Goods Sold Gross Profit Depreciation Expense Salaries and Wages Expense Net Income Accounts Receivable Inventory Accounts Payable...
-
What is meant by value in earned value?
-
Classify each of the following variables as categorical or quantitative. a. The number of social media accounts you have (Facebook, Twitter, LinkedIn, Instagram, etc.) b. Preferred soccer team c....
-
Which of your personal attributes will most help you succeed as an entrepreneur?
-
Of all cancer cases around the world in 2012, 13% had lung cancer, 11.9% had breast cancer, 9.7% had colorectal cancer, 7.9% had prostate cancer, 6.8% had stomach cancer, and 50.7% had other types of...
-
What sources of capital do you have? Are you willing to take on a home equity loan? Use your personal credit cards? How much of a nest egg do you need to feel comfortable pursuing a new venture?
-
What fiduciary duty do you have with your current employer? Does your proposed new venture rely on proprietary information belonging to your previous employer? Are you materially interfering with...
-
The pH of an aqueous solution of 3.0810 -2 M ammonium chloride , NH 4 Cl (aq), is . This solution is _________ acidic basic neutral acidic, basic, or neutral?
-
The figure shows a bolted lap joint that uses SAE grade 8 bolts. The members are made of cold-drawn AISI 1040 steel. Find the safe tensile shear load F that can be applied to this connection if the...
-
At the market equilibrium price and quantity, the total welfare gains from trade are measured by a. the total consumer surplus captured by consumers. b. the total producer surplus captured by...
-
Which of the following is not true about consumer surplus? a. Consumer surplus is the difference between what consumers are willing to pay and what they actually pay. b. Consumer surplus is shown...
-
In a supply and demand graph, the triangular area under the demand curve but above the market price is a. the consumer surplus. b. the producer surplus. c. the marginal cost. d. the deadweight loss....
Study smarter with the SolutionInn App