0% found this document useful (0 votes)
5 views4 pages

Investment Analysis and Loan Amortization

The document discusses investing $130,000 in new software that is estimated to provide savings over 5 years ranging from $35,000 in year 1 to $15,000 in year 5. It calculates the present value of each year's savings and finds the total present value is $136,401.93, which is greater than the $130,000 investment. Therefore, the firm should make the investment since the gain is more than the amount invested.
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
5 views4 pages

Investment Analysis and Loan Amortization

The document discusses investing $130,000 in new software that is estimated to provide savings over 5 years ranging from $35,000 in year 1 to $15,000 in year 5. It calculates the present value of each year's savings and finds the total present value is $136,401.93, which is greater than the $130,000 investment. Therefore, the firm should make the investment since the gain is more than the amount invested.
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

2.

Your firm has the option if making an investment in a new software that will cost $130,000 today and it is estimated to pro

Year Savings E. PV= FV(1+r)^n


1 $35,000 PV= 35,000(1+.09)^-1 32,110.09
2 $50,000 PV= 50,000(1+.09)^-2 42,083.99
3 $45,000 PV= 45,000(1+.09)^-3 34,748.25 Total = 136,401.93
4 $25,000 PV= 25,000(1+.09)^-4 17,710.63
5 $15,000 PV= 15,000(1+.09)^-5 9,748.97

Should the firm make its investment if it requires a minimum annual return of 9% on all investments?
Yes, because it has more gain that what it was invested.
ay and it is estimated to provide the savings shown in the following table over its 5-years life.
5. Joan Messineo borrowed $15,000 at 14% annual rate of interest to be repaid over 3 years. The loan is amortized into three
a) Calculate the annual, end-of-year loan payment
b) Prepare loan amortization schedule showing the interest and principal breakdown of eash of the three loan payments.
c) Explain why the interest portion of each payment declines with the passage of time.

a)
CF= (PV . R) (15, 000) 0.14 $6,460.97
1- 1/ (1+r)n 1 - 1
(1+ 0.14) 3

b)
EOY BOY Loan Payment Interest Principal EOY Principal
1 15000 $6,460.97 2100 4360.97 10,639.03
2 12639.03 $6,460.97 1489.46 4971.51 5667.52
3 5667.52 $6,460.97 793.45 5667.52 0

c)
Because is calulated according the amount of the beginning of the year, if the amount decrease, the interese will decrease as w
an is amortized into three equal, annual, end-of-year payments.

three loan payments.

nterese will decrease as well.

Common questions

Powered by AI

A positive NPV in investment projects results from expected cash inflows exceeding initial and discounted outflows. Key factors include accurate forecasting of future cash flows, selecting an appropriate discount rate reflecting the project’s risk, and managing costs effectively. Additionally, external market conditions, economic factors impacting cash flow forecasts, and strategic alignment with company goals contribute significantly. In the given project, precise calculation of present values at a 9% discount rate ensured that the expected savings totaling $136,401.93 exceeded the $130,000 initial cost, resulting in a positive NPV .

As the principal balance of an amortized loan decreases over time, the interest component of each payment also declines. This occurs because the interest is calculated on the outstanding principal balance; therefore, as the principal is repaid, the amount subject to interest reduces. In Joan Messineo's case, the interest portion starts at $2,100 and declines to $1,489.46 in the second year and $793.45 in the final year as the principal decreases from $15,000 to $5,667.52 by the end of the term .

Firms require a minimum annual return on investments to ensure that they meet or exceed expected profitability thresholds, reflecting the firm's opportunity cost of capital. This benchmark not only compensates for the risk taken but also aligns with the objectives of wealth maximization and competitive positioning. By ensuring investments yield a minimum return, firms safeguard against potential underperformance and secure returns that meet stakeholder expectations, as demonstrated in the investment decision requiring a 9% return, which resulted in a positive NPV .

The interest portion of an amortized loan payment is calculated on the outstanding principal balance at the start of each period. As the principal is gradually repaid with each scheduled payment, the amount subject to interest decreases. Consequently, the interest portion reduces over time since each subsequent payment comprises a smaller interest and larger principal repayment. For example, Joan Messineo’s loan payments show a decline in interest from $2,100 to $793.45 over the three-year term as the principal decreases .

Before investing in new technology, firms should evaluate strategic considerations such as the potential for competitive advantage, alignment with long-term goals, adaptability to future trends, risk of technological obsolescence, and total cost of ownership versus projected savings. They should also consider the impact on operational efficiency and scalability, potential disruptions during implementation, and technology's integration with existing systems. As illustrated by the software investment providing $136,401.93 in savings against a $130,000 cost, ensuring alignment with financial and strategic objectives is paramount for investment viability .

The Net Present Value (NPV) of the investment is calculated by summing the present values of the expected savings over five years: $32,110.09 in Year 1, $42,083.99 in Year 2, $34,748.25 in Year 3, $17,710.63 in Year 4, and $9,748.97 in Year 5, totaling $136,401.93 . Given the software costs $130,000 today, the NPV is $136,401.93 - $130,000 = $6,401.93. Since the NPV is positive and exceeds the initial investment, the firm should proceed with the investment if it requires a minimum annual return of 9% .

Firms select projects with a positive Net Present Value (NPV) because a positive NPV indicates that the project's expected returns exceed the costs when discounted at the required rate of return, effectively adding value to the company. Positive NPVs account for varying risk levels by reflecting the risk factor in the discount rate applied. While higher risks would demand higher returns to achieve a positive NPV, selecting such projects can enhance shareholder value and align with the company’s strategic goals despite potential risks .

Calculating the present value of future cash flows allows investors to assess the time value of money by discounting future savings or returns to their present worth. This method provides a clearer picture of an investment’s profitability by ensuring that future benefits justify the initial costs. For example, calculating the present values of projected savings in different years resulted in a cumulative total of $136,401.93, which exceeds the initial investment cost of $130,000, thus influencing the decision to proceed with the investment . It aligns investment choices with financial objectives through more accurate risk-adjusted evaluations .

Evaluating the financial decision for a long-term investment involves assessing the projected savings against the current expenditure and discounting future savings to present value using a required rate of return. Despite potential uncertainty, if the NPV is positive, as demonstrated by a project with year-on-year savings totaling $136,401.93 against an investment of $130,000, it suggests that the project is financially sound . However, the firm must also consider risk factors, market conditions, and opportunity costs that might affect these savings. Sensitivity analysis and scenario planning can better inform these decisions by accounting for varying outcomes and levels of uncertainty .

Amortization affects the total interest paid by decreasing the principal balance over time, which reduces the amount of interest accrued in each subsequent period. For Joan Messineo's loan, the interest portion of each payment declines over time because it is calculated on the remaining principal balance, which decreases with each payment. Initially, the interest is $2,100 on a $15,000 loan. By the second payment, the interest reduces to $1,489.46 as the balance decreases to $12,639.03, and finally $793.45 by the third payment when the principal is $5,667.52 .

You might also like