Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Oct 19, 2024

Build a amortization table for the loan below add extra payment to pay off early by no more the 6 months (the loan payment must

Build a amortization table for the loan below add extra payment to pay off early by no more the 6 months (the loan payment must last 4.5 years even with early payoff) . Show the money saved.

$35,000 loan, 5 years, 5.9% interest, monthly payments with no balloon.

Create an annuity solution to find the payment in Excel (that's the N I/Y PV PMT FV) and then do the amortization table for it.

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

Project Finance in Theory and Practice

Authors: Stefano Gatti

2nd edition

978-9382291589, 123919460, 978-0124157538, 978-0123919465

More Books

Students also viewed these Finance questions

Question

★★★★★

Nitrogen is heated from 20C to 500C. Calculate the change in the internal energy and enthalpy. Use: i) Constant specific heats from Table B-2 ii) The ideal-gas table in Appendix F iii) The average...

Answered: 1 week ago

Question

★★★★★

A portion of the combined statement of income and retained earnings of Shamrock Inc. for the current year follows. Income before extraordinary item $15,080,000 Loss from discontinued operations, net...

Answered: 1 week ago

Question

★★★★★

Articulate the strategic role of human resource management in the international business.

Answered: 1 week ago

Question

★★★★★

Westwood Furniture Company is considering the purchase of two different items of equipment, as described below: Machine A A compacting machine has just come onto the market that would permit Westwood...

Answered: 1 week ago

Question

★★★★★

Build a amortization table for the loan below add extra payment to pay off early by no more the 6 months (the loan payment must last 4.5 years even with early payoff) . Show the money saved. $35,000...

Answered: 1 week ago

Question

★★★★★

Answered: 1 week ago

Question

★★★★★

On the Customers worksheet, use TEXTJOIN to return Wilbur's first and last name, separated by a space, to D4. Then copy the formula to D5:D13

Answered: 1 week ago

Question

★★★★★

- 2. As we have seen with waves on a string, the "springiness" of a material is one property that goes toward determining the speed at which waves travel through it. We also saw that the mass density...

Answered: 1 week ago

Question

★★★★★

2. Assume that you are planning to build a House for your family. List out the important events (at least 8) of this project with the time and cost estimates. You can use any open source data to...

Answered: 1 week ago

Question

★★★★★

land value for 2022 was 110,00 and for 2023 is 104,000. the land was sold with a a gain of 7,400. Calculate amounts to enter in a statement of cash flows for 2023

Answered: 1 week ago

Question

★★★★★

(C) Three pinned-end columns have the same material, same length and same cross-sectional area as shown in Fig. 2. The columns are free to buckle in any direction. The columns have cross sections as...

Answered: 1 week ago

Previous Question Next Question