Free

Net Present Value - Coursework Example

Comments (0) Cite this document
Summary
The NPV of the project is -$1,598,490.88, which implies that, the project is not likely to receive the expected return at the end of…
Download full paperFile format: .doc, available for editing
GRAB THE BEST PAPER94.6% of users find it useful
Net Present Value
Read TextPreview

Extract of sample "Net Present Value"

Net Present Value Learner’s Affiliated institute Net Present Value Initial investment 600,000  Duration = 5 years Rate = 10%
Cash flow:
Year 1: $380,000
Year 2: $390,000
Year 3: $400,000
Year 4: $410,000
Year 5: $420,000
Net Present Value: -$1,598,490.88
PV of Expected Cash Flows: $1,509.12
Discussion
At a rate of 10.00% and for a period of 5 years, the projected cash flows are worth $1,509.12 today, which is less than the initial $1,600,000.00. The NPV of the project is -$1,598,490.88, which implies that, the project is not likely to receive the expected return at the end of the project. For this reason, pursuing this project may not be an optimal decision.
However, despite the fact that, the projected capital project resulted in a negative NPV value, it may still be beneficial engaging. One of the factors that may increase NPV of a project is the valuation of real options. For instance, projects such as research and development are risky to venture. As a result od that, the returns from such projects cannot be guaranteed. However, if the projects are successful, their payoff are usually very high.
As an Alternately, it is also possible that the NPV is negative, with the reason being that, the required return rate is unrealistically high. It may also be the case if the projected cash flow is too conservative.
LOAN AMORTIZATION SCHEDULE
Loan Summary$1,600,000 for 10 years with a 6% interest rate
$17,763.28
Monthly Payment
$2,131,593.64
Total of 120 Payments
Mar, 2025
Payoff Date
Loan Amortization Schedule
Date
Interest
Principal
Balance
Apr, 2015
$8,000.00
$9,763.28
$1,590,236.72
May, 2015
$7,951.18
$9,812.10
$1,580,424.62
Jun, 2015
$7,902.12
$9,861.16
$1,570,563.47
Jul, 2015
$7,852.82
$9,910.46
$1,560,653.00
Aug, 2015
$7,803.27
$9,960.02
$1,550,692.99
Sep, 2015
$7,753.46
$10,009.82
$1,540,683.17
Oct, 2015
$7,703.42
$10,059.86
$1,530,623.31
Nov, 2015
$7,653.12
$10,110.16
$1,520,513.14
Dec, 2015
$7,602.57
$10,160.71
$1,510,352.43
2015
$70,221.95
$89,647.57
$1,510,352.43
Jan, 2016
$7,551.76
$10,211.52
$1,500,140.91
Feb, 2016
$7,500.70
$10,262.58
$1,489,878.34
Mar, 2016
$7,449.39
$10,313.89
$1,479,564.45
Apr, 2016
$7,397.82
$10,365.46
$1,469,198.99
May, 2016
$7,345.99
$10,417.29
$1,458,781.70
Jun, 2016
$7,293.91
$10,469.37
$1,448,312.33
Jul, 2016
$7,241.56
$10,521.72
$1,437,790.61
Aug, 2016
$7,188.95
$10,574.33
$1,427,216.29
Sep, 2016
$7,136.08
$10,627.20
$1,416,589.09
Oct, 2016
$7,082.95
$10,680.33
$1,405,908.75
Nov, 2016
$7,029.54
$10,733.74
$1,395,175.02
Dec, 2016
$6,975.88
$10,787.41
$1,384,387.61
2016
$87,194.54
$125,964.82
$1,384,387.61
Jan, 2017
$6,921.94
$10,841.34
$1,373,546.27
Feb, 2017
$6,867.73
$10,895.55
$1,362,650.72
Mar, 2017
$6,813.25
$10,950.03
$1,351,700.69
Apr, 2017
$6,758.50
$11,004.78
$1,340,695.92
May, 2017
$6,703.48
$11,059.80
$1,329,636.11
Jun, 2017
$6,648.18
$11,115.10
$1,318,521.01
Jul, 2017
$6,592.61
$11,170.68
$1,307,350.34
Aug, 2017
$6,536.75
$11,226.53
$1,296,123.81
Sep, 2017
$6,480.62
$11,282.66
$1,284,841.15
Oct, 2017
$6,424.21
$11,339.07
$1,273,502.08
Nov, 2017
$6,367.51
$11,395.77
$1,262,106.31
Dec, 2017
$6,310.53
$11,452.75
$1,250,653.56
2017
$79,425.31
$133,734.05
$1,250,653.56
Jan, 2018
$6,253.27
$11,510.01
$1,239,143.54
Feb, 2018
$6,195.72
$11,567.56
$1,227,575.98
Mar, 2018
$6,137.88
$11,625.40
$1,215,950.58
Apr, 2018
$6,079.75
$11,683.53
$1,204,267.05
May, 2018
$6,021.34
$11,741.95
$1,192,525.11
Jun, 2018
$5,962.63
$11,800.65
$1,180,724.45
Jul, 2018
$5,903.62
$11,859.66
$1,168,864.80
Aug, 2018
$5,844.32
$11,918.96
$1,156,945.84
Sep, 2018
$5,784.73
$11,978.55
$1,144,967.29
Oct, 2018
$5,724.84
$12,038.44
$1,132,928.84
Nov, 2018
$5,664.64
$12,098.64
$1,120,830.21
Dec, 2018
$5,604.15
$12,159.13
$1,108,671.08
2018
$71,176.89
$141,982.48
$1,108,671.08
Jan, 2019
$5,543.36
$12,219.92
$1,096,451.15
Feb, 2019
$5,482.26
$12,281.02
$1,084,170.13
Mar, 2019
$5,420.85
$12,342.43
$1,071,827.70
Apr, 2019
$5,359.14
$12,404.14
$1,059,423.56
May, 2019
$5,297.12
$12,466.16
$1,046,957.40
Jun, 2019
$5,234.79
$12,528.49
$1,034,428.90
Jul, 2019
$5,172.14
$12,591.14
$1,021,837.77
Aug, 2019
$5,109.19
$12,654.09
$1,009,183.67
Sep, 2019
$5,045.92
$12,717.36
$996,466.31
Oct, 2019
$4,982.33
$12,780.95
$983,685.36
Nov, 2019
$4,918.43
$12,844.85
$970,840.51
Dec, 2019
$4,854.20
$12,909.08
$957,931.43
2019
$62,419.72
$150,739.65
$957,931.43
Jan, 2020
$4,789.66
$12,973.62
$944,957.81
Feb, 2020
$4,724.79
$13,038.49
$931,919.32
Mar, 2020
$4,659.60
$13,103.68
$918,815.63
Apr, 2020
$4,594.08
$13,169.20
$905,646.43
May, 2020
$4,528.23
$13,235.05
$892,411.38
Jun, 2020
$4,462.06
$13,301.22
$879,110.16
Jul, 2020
$4,395.55
$13,367.73
$865,742.43
Aug, 2020
$4,328.71
$13,434.57
$852,307.86
Sep, 2020
$4,261.54
$13,501.74
$838,806.12
Oct, 2020
$4,194.03
$13,569.25
$825,236.87
Nov, 2020
$4,126.18
$13,637.10
$811,599.78
Dec, 2020
$4,058.00
$13,705.28
$797,894.50
2020
$53,122.43
$160,036.94
$797,894.50
Jan, 2021
$3,989.47
$13,773.81
$784,120.69
Feb, 2021
$3,920.60
$13,842.68
$770,278.01
Mar, 2021
$3,851.39
$13,911.89
$756,366.12
Apr, 2021
$3,781.83
$13,981.45
$742,384.67
May, 2021
$3,711.92
$14,051.36
$728,333.31
Jun, 2021
$3,641.67
$14,121.61
$714,211.70
Jul, 2021
$3,571.06
$14,192.22
$700,019.48
Aug, 2021
$3,500.10
$14,263.18
$685,756.30
Sep, 2021
$3,428.78
$14,334.50
$671,421.80
Oct, 2021
$3,357.11
$14,406.17
$657,015.63
Nov, 2021
$3,285.08
$14,478.20
$642,537.42
Dec, 2021
$3,212.69
$14,550.59
$627,986.83
2021
$43,251.70
$169,907.67
$627,986.83
Jan, 2022
$3,139.93
$14,623.35
$613,363.48
Feb, 2022
$3,066.82
$14,696.46
$598,667.02
Mar, 2022
$2,993.34
$14,769.95
$583,897.08
Apr, 2022
$2,919.49
$14,843.79
$569,053.28
May, 2022
$2,845.27
$14,918.01
$554,135.27
Jun, 2022
$2,770.68
$14,992.60
$539,142.66
Jul, 2022
$2,695.71
$15,067.57
$524,075.10
Aug, 2022
$2,620.38
$15,142.90
$508,932.19
Sep, 2022
$2,544.66
$15,218.62
$493,713.57
Oct, 2022
$2,468.57
$15,294.71
$478,418.86
Nov, 2022
$2,392.09
$15,371.19
$463,047.67
Dec, 2022
$2,315.24
$15,448.04
$447,599.63
2022
$32,772.17
$180,387.20
$447,599.63
Jan, 2023
$2,238.00
$15,525.28
$432,074.35
Feb, 2023
$2,160.37
$15,602.91
$416,471.44
Mar, 2023
$2,082.36
$15,680.92
$400,790.52
Apr, 2023
$2,003.95
$15,759.33
$385,031.19
May, 2023
$1,925.16
$15,838.12
$369,193.07
Jun, 2023
$1,845.97
$15,917.31
$353,275.75
Jul, 2023
$1,766.38
$15,996.90
$337,278.85
Aug, 2023
$1,686.39
$16,076.89
$321,201.96
Sep, 2023
$1,606.01
$16,157.27
$305,044.69
Oct, 2023
$1,525.22
$16,238.06
$288,806.64
Nov, 2023
$1,444.03
$16,319.25
$272,487.39
Dec, 2023
$1,362.44
$16,400.84
$256,086.54
2023
$21,646.28
$191,513.09
$256,086.54
Jan, 2024
$1,280.43
$16,482.85
$239,603.70
Feb, 2024
$1,198.02
$16,565.26
$223,038.44
Mar, 2024
$1,115.19
$16,648.09
$206,390.35
Apr, 2024
$1,031.95
$16,731.33
$189,659.02
May, 2024
$948.30
$16,814.99
$172,844.03
Jun, 2024
$864.22
$16,899.06
$155,944.97
Jul, 2024
$779.72
$16,983.56
$138,961.42
Aug, 2024
$694.81
$17,068.47
$121,892.94
Sep, 2024
$609.46
$17,153.82
$104,739.13
Oct, 2024
$523.70
$17,239.58
$87,499.54
Nov, 2024
$437.50
$17,325.78
$70,173.76
Dec, 2024
$350.87
$17,412.41
$52,761.35
2024
$9,834.17
$203,325.19
$52,761.35
Jan, 2025
$263.81
$17,499.47
$35,261.88
Feb, 2025
$176.31
$17,586.97
$17,674.91
Mar, 2025
$88.37
$17,674.91
$0.00
2025
$528.49
$52,761.35
$0.00
Reference
Investopedia,. (2015). Net Present Value Calculator | Investopedia. Retrieved 26 April 2015, from http://www.investopedia.com/calculator/netpresentvalue.aspx Read More
Cite this document
  • APA
  • MLA
  • CHICAGO
(“Net Present Value Coursework Example | Topics and Well Written Essays - 250 words”, n.d.)
Net Present Value Coursework Example | Topics and Well Written Essays - 250 words. Retrieved from https://studentshare.org/business/1691551-net-present-value
(Net Present Value Coursework Example | Topics and Well Written Essays - 250 Words)
Net Present Value Coursework Example | Topics and Well Written Essays - 250 Words. https://studentshare.org/business/1691551-net-present-value.
“Net Present Value Coursework Example | Topics and Well Written Essays - 250 Words”, n.d. https://studentshare.org/business/1691551-net-present-value.
  • Cited: 0 times
Comments (0)
Click to create a comment or rate a document

CHECK THESE SAMPLES OF Net Present Value

Primary Drawbacks of Net Present Value as Capital Budgeting Technique

...?Question Primary Drawbacks of Net Present Value as Capital Budgeting Technique: This method or tool is used to assess the profitability of an investment opportunity. This tool is classified as one of the capital budgeting technique that is used by a firm to assess the viability of a project. The application of this tool is dependent upon the future cash flows that the investment opportunity or project will generate. This technique takes future cash flows generated by an investment opportunity and discount them to reach the present value of those cash flows. This entire process has multiple loopholes, for instance the uncertainty that is prevailing when...
6 Pages(1500 words)Assignment

Behavioral Assessment

4 Pages(1000 words)Research Paper

Net Present Value and Internal Rate of Return

...Financial Management Question Net Present Value In evaluating the viability of the expansion of Bradford Renovation and Rebuild Ltd, the Net Present Value (NPV) method will be utilized. Economists argued that NPV is a better alternative in capital budgeting decisions because it takes into account the time value of money. The net present value (NPV) of a project represents the present value of the total cash inflows and outflows (Net Present Value 2006). The NPV can be calculated by...
10 Pages(2500 words)Assignment

Finance: net present value

...(sw) 46.50 47.69 48.93 50.21 Sales value ('000') 2790 5245.9 4893 1506.3 Year 1 Year 2 Year 3 Year 4 Flute ('000') ('000') ('000') ('000') Sales volume 75 137.5 125 37.5 Sales price 34.50 35.39 36.32 37.28 Sales value ('000') 2587.5 4866.125 4540 1398 Total sales value ('000') 5377.5 10112.025 9433 2904 Less advertising costs 750 300 300 (-) Earnings before interest 4627.5 9812.025 9133 2904 Depreciation and tax Less tax (-) (-) (-) (-) Operating net cashflow 4627.5 98.12.025 9133 2904 NPV CALCULATION Year Cashflow (a) PVI fr% np (b) Present Value(c) =ax b...
6 Pages(1500 words)Essay

Net Present value

...PART A Net Present value 2. Pay Back period 3. Internal rate of Return In the NPV calculation above the rate of interest used is 20% whereby the NPV of cash flows is -1940. At IRR rate NPV has to be zero. So using interest rate of 21% NPV is calculated again as under 4. Appraisal on selling price lowered by 3 pence 5. Appraisal when sale volume greater by 10% Please note that operational cost being fixed will not change with change sale volume. 6) Year sales in units = 52000 units Assuming contribution is 20% Sales = (30400/20) * 100 = 152000 Then Sales per unit = ((30400/20) * 100) / 52000 = £2.92 per unit (rounded) Yearly sale on 900 units per week = 900 * 52 = 46800...
5 Pages(1250 words)Essay

Market prices, Valuation Principle, Net present Value, interest rates, and bonds

...Market prices, Valuation Principle, Net present Value, Interest rates, and Bonds Market prices, Valuation Principle, Net present Value, Interest rates, and Bonds Your Name: School Affiliation: Market prices, Valuation Principle, Net present Value, Interest rates, and Bonds Identify the components of a stock’s realized return. Realized return is the value of actual gains that owner of the stock earned on the value of investment over specific period of time. Stock’s realized return has the components of stock value (value...
2 Pages(500 words)Essay

The Net Present Value (NPV)

...Exercise The Net Present Value (NPV) Model a) Year Cash flow PVIF 10%, n Present value -50,000 50,000 12,000 0.909 10,908 16,000 0.826 13,216 2014 20,000 0.751 15,020 2015 24,000 0.683 16,392 2016 28,000 0.621 17,388 NPV 22,924 i) This is a worthwhile investment to venture into since it results in a positive NPV. Therefore, the present value of the cash flows expected is more than the present value of the initial cash outlay incurred at the beginning. ii) Due to time value of money, the value of money now would be much less in one year since money loses value as time passes. This means that it is prudent for an investor to consider the present value of the expected net returns and compare this with the present value of the initial... ...
6 Pages(1500 words)Assignment

Net Present Value Model (NPV)

...Question The three main capital budgeting techniques are payback period, net present value (NPV) and internal rate of return (IRR). The payback period calculates the number of years that it takes a company to recover its original investment. An advantage of this method is that it is simple to calculate. A con of the payback period is that it does not take into consideration the time value of money. The net present value calculates the present value of future cash flows of a project. A project is accepted only if the present value is above cero. An...
1 Pages(250 words)Coursework

Net Present Value

...The concept of net present value is an analytic tool that can help both corporations and novice investors. From an investor standpoint the use of netpresent value is very useful because net present value takes into consideration the time value of money. Due to inflation money depreciates over time. A person has $100 saved up in a cookie jar and leaves it there for five years will lose money because those $100 will not have the same purchasing power five years into the future. Using the net present value table can help a person determine how much interest...
1 Pages(250 words)Essay

Calculating cash flow and net present value (see paper for details)

...CALCULATING CASH FLOW AND NET PRESENT VALUE Question a Capital outflows refer to those cash outflows incurred on the acquisition of non-current assets, including any subsequent cash outflows borne in order to bring such assets into their present location and condition (Porter & Norton, 2008). These outflows are of a one-off kind and their benefits are derived over several accounting periods. Such costs as presented in the case of this manufacturing organization is the acquisition of the new machinery at a cost of £300K, removal of the old machinery at a cost of £30K and the installation cost of £60K. On the other hand, revenue outflows are those cash outflows incurred so as to maintain the earning capacity of assets (Clarke, 2002... ...
1 Pages(250 words)Assignment
sponsored ads
We use cookies to create the best experience for you. Keep on browsing if you are OK with that, or find out how to manage cookies.

Let us find you another Coursework on topic Net Present Value for FREE!

Contact Us