Question: please solve in excel with all the formulas shown Garfield is repaying a debt with 20 annual payments of 1000 each. At the end of

please solve in excel with all the formulas shown

Garfield is repaying a debt with 20 annual payments of 1000 each. At the end of the fourth year, he makes an extra payment of 2000, He then shortens his remaining payment period by two years, and makes level payments over that time. If i = .12, find the revised annual payment

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Garfield is repaying a debt with 20 annual payments of 1000 each. At the end of the fourth year, he makes an extra payment of 2000. He then shortens his remaining payment period by two years, and...

Garfield is repaying debt with 20 annual payments of 1000 each. At the end of the fourth year, he makes an extra payment of 2000. He then shortens his remaining payment period by two years and makes...

financial SUBDOMAINS: 325.4 COMMUNICATING EFFECTIVELY IN ORGANIZATIONS 326.1 MANAGING INTERNAL COST & CONTROLLING FINANCES 326.2 MANAGING CAPITAL & FINANCIAL ASSETS 326.4 MANAGING ENTERPRISE RISK &...

please answer all of the question with detailes i have the answers ,but i need the way the were solved SS, Inc. Balance Sheet December 31, 2013 Assets Current Assets Cash Accounts Receivable Less:...

The Appendix Info is attached at the bottom. Please help with these questions. Les Moore retired as president of Goodman Snack Foods Company but is currently on a consulting contract for $52,000 per...

All supplemental Documents are Attached (Appendix A-D) Please help the questions below Les Moore retired as president of Goodman Snack Foods Company but is currently on a consulting contract for...

i got this exam and i need the answers in detailes please there are two attachment one of them the questions and the other answers 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26...

please solve in Excel with showing all the formulas, thank you 1-14. The original amount of an inheritance was just sufficient at 8% effective to pay 5000 at the end of each year for 10 years. The...

I need help with A, b,c, and e The excel to the right has been started so it needs to be in that format. Please show it in an excel spread sheet with formulas shown per cell. Etc.Thank you A B C D E...

Target Market Source of Capital Proportions Long-term debt 30% Preferred stock 5% Common stock equity 65% Debt: The firm can sell a 10-year, $1,000 par value, 7 percent bond for $950. A flotation...

21. Alberts mother signed a three-month listing agreement with a real estate agent. Prior to considering or accepting either of two below-listing-price offers the agent brought to Alberts mother, she...

2. A sample of drivers recorded the distance of their morning commute below: 45 10 6 19 23 15 14 12 12 48 20 17 11 8 15 3 a. Find the mean and standard deviation. (3pts) b. Use part (a) to determine...

What principle does the dual problem lead to for investors? There is no dual problem for investing. Investors demand to be properly compensated for the level of risk of the investment. Investors...

1:58 PM Thu Jul 14 87% @@@ooo-- Lab7: Impulse In Motion: Equipment: 1. Photogate, qty 2. 2. Collision carts with detachable magnetics, qty 2. 3. Car track, qty 1. 4. Balance/Scale, qtyl. 5. Photogate...

4. Some politicians have suggested that the United States enact a constitutional amendment requiring that the federal government balance its budget annually. Explain why such an amendment, if...

12. last word What do economists mean when they say Social Security and Medicare are pay-as-you-go plans? What are the Social Security and Medicare trust funds, and how long will they have money left...

1. Which of the following would help a government reduce an inflationary output gap? LO33.1 a. Raising taxes. b. Lowering taxes. c. Increasing government spending. d. Decreasing government spending.