4  Financial Project Evaluation

For which of you, intending to build a tower, sitteth not down first, and counteth the cost, whether he have sufficient to finish it? Lest haply, after he hath laid the foundation, and is not able to finish it, all that behold it begin to mock him, Saying, This man began to build, and was not able to finish. Luke 14

Infrastructure takes money to build. Money is needed to pay for the people to plan and build projects including tradesmen, construction managers, and engineers. Money is also needed for things such as building supplies, construction equipment and land on which the project is to be built. How can you know if the money you spend on a project will be worth it? How can you decide which version of a project to build? How can you deal with the fact that money now is worth more than money later?

Private businesses will evaluate a construction project as to whether it can return a reasonable profit. Governments may choose to build a project that provides the most benefits for their citizens at the lowest cost. Either way, a well-informed business, non-profit organization, or government will conduct a financial analysis of a potential construction project before committing to it. In addition, a financial analysis can guide planners, engineers, and construction managers on the appropriate design, scope, timeline, and resulting costs of an infrastructure project.

Think

Many of the principles and techniques you learn in this unit can apply to your own life, despite the meaningful differences between running a government or business and running a home. President Gordon B. Hinckley cautioned,

I recognize that it may be necessary to borrow to get a home, of course. But let us buy a home that we can afford and thus ease the payments which will constantly hang over our heads without mercy or respite for as long as 30 years. … I urge you, brethren, to look to the condition of your finances. I urge you to be modest in your expenditures; discipline yourselves in your purchases to avoid debt to the extent possible. Pay off debt as quickly as you can, and free yourselves from bondage.

Important

Many of the terms we use in this unit are used casually or differently by individuals, businesses, and industries (). In this class, we will try to be consistent with our use of these terms. As a professional, it will be your responsibility to understand how each term is defined when evaluating financial analysis of a project or when communicating your results to others.

If you are unfamiliar with a term, look it up! Or ask! There are many good credible resources online. For example, see the Investopedia Dictionary () and the U.S. Consumer Financial Protection Bureau glossary ().

As always, you should know definitions for the terms in bold.

4.1 Returns and Investments

Whenever you have a financial project — this can be something as basic as a savings account or as complex and large as a multi-year heavy civil construction project — you are hopeful that what you get out of the project will be worth at least as much as you put into it. After all, if you don’t get more money than you started with, why even do it? You might as well have put your money in a piggy bank.

What we put into a project is called its investment. What we get out of a project are called its returns. Mathematically, the returns are

(4.1)Returns=RevenueExpensesInterestTaxes+Δ(Asset Value)

Each of these terms in deserves a definition.

  • Revenue is the money earned from a project.
  • Expenses are money spent during a project in order to operate it.
  • Interest are payments that are required by any debt associated with the project.
  • Taxes are payments to the government required as part of a project’s operations or profits.
  • Assets are resources associated with the project. The value of an asset might go up or down based on market conditions, improvements that are made to the asset, or the loss of the asset’s usefulness.
Flipping Returns

You decide to “flip” a house in Provo. This means you want to buy a house, rennovate the house, and sell it for a higher value than you bought it for. If you buy the house for $400,000, spend $80,000 on rennovations, and sell it for $600,000, what are your returns?


The value of the asset when you purchased it includes the amount you spent to fix it up, and so the only part of this equation that matters is the Δ(Asset Value) portion. Starting from ,

Returns=RevenueExpensesInterestTaxes+Δ(Asset Value)=0000+[600,000(400,000+80,000)]=120,000

Any positive return is better than a loss, but a small positive return on a massive investment would be disappointing. A measure the effectiveness of an investment is return on investment or ROI. This is simply the ratio of returns to investments, or

(4.2)ROI=ReturnsCost of Investment

We often describe ROI as a percentage.

Flipping ROI

For the house flipping project described in the previous example, what is the ROI?


We determined earlier that our returns were $120,000 on an investment of $480000 so the ROI is (using )

ROI=ReturnInvestment=120000480000=0.25

Or, an ROI of 25%.

Payback Period

Another basic measure of the effectiveness of an investment is the payback period. This is the inverse of ROI if the returns are in per-year increments.

(4.3)Payback[time]=Investment$Returns$/time

Payback

Assume that you have an investment that costs $100k and brings $8k returns per year. What is the ROI if you do this for one year? What is the payback period?


The ROI is (using ) ROI=ReturnInvestment=8000100000=0.08

and the payback period (using ) is

Payback=1000008000$$/yr=12.5years

Let’s explore the other parts of the Returns equation in . If you have operating expenses or are collecting revenue from your project, you need to account for that in your calculations of the returns.

Flipping with Rent

You decide to rent the house in Provo out for a year after fixing it and before selling it. Your renters will pay $2000 per month, but you have to pay $400 per month in utilities. Additionally, your tenants inform you that one of the toilets backs up regularly and you have to pay $5000 to repair the sewer line and some related damage. What is the ROI for this project?


It is impossible to calculate the ROI without first calculating the returns using . The renters bring revenue for each month, with expenses related to the utilities and the sewer repair.

Returns=RevenueExpensesInterestTaxes+Δ(Asset Value)=12×2000(12×400+5000)00+[600,000(400,000+80,000)]=134,200

The ROI can then be had using

ROI=ReturnCost of Investment=134200480000=0.28

So with an ROI of almost 28%, it would be more profitable to rent for a year than to sell immediately, assuming that you can get the same sale price.

Expenses vs Investments

What is an expense and what is an investment? Expenses and investments in a project each reduce the returns in , so why does it matter where you put them? When you are calculating the taxable income on your project, you can often deduct expenses, but you cannot usually deduct investments.

Where you put investments and where you put expenses also affects the ROI. In the prior example, the sewer line repair is an expense of operating the project. If you had preemptively fixed the sewer line, then it would have counted as part of your initial investment; you would have had the same returns but a lower ROI because your investment was bigger.

So pay attention to where you are putting what!

What happens when you use debt to start a project? This will decrease the returns from the project, because you will have to pay interest to the person who lent you the money. The amount you pay in interest in a period is usually the interest rate given with the loan multiplied by how much you borrow:

(4.4)Interest=Interest rate×Principal

Warning

Interest rates are usually given in percentages (12%), but should be used as decimal proportions in equations (0.12).

But you won’t have to invest as much in the project to start with, because that money isn’t yours. This can substantially increase the profitability of the project.

Flipping with Debt

You decide to take out a loan to purchase the house that you want to repair and then rent. The bank is willing to offer you a loan at 7.5%, with a 30% down payment on the house price. What is the ROI now?


Our investment changes because instead of paying for the entire house, we only pay for 30%×$400,000=$120,000 of the purchase, plus the $80,000 it takes to repair the house.

The returns also change, because we now have to make an interest payment for how much of the money we borrowed, which is 70% of the house price or $280,000. Using ,

Returns=RevenueExpensesInterestTaxes+Δ(Asset Value)=12×2000(12×400+5000)(0.075×280000)0+[600,000(400,000+80,000)]=113,200

Your ROI is therefore

ROI=ReturnCost of Investment=113,200120000+80000=0.566

This ROI of 56.6% is almost twice the ROI we had before!

You might wonder why the loan didn’t affect the change in the asset value. After all, we have to pay back the bank right? Well, if we had included the $280,000 we had to pay to the bank, then we should have also included the $280,000 we got from the bank at the beginning of the year. So we could add and substract the $280,000 inside the Δ(Asset Price) segment, but it would not have made a difference to the calculation.

This process of using debt to increase the profitability of a project is called leveraging. There are of course pros and cons associated using debt in this way. The returns go down, meaning that doing one project with debt would be a little less profitable than doing one project without it. But because you have less of your own resources invested in that one project, you could maybe do two projects! In that way you can increase your total overall returns across for the same amount of investment. That’s why ROI is a good measure.

The cons of using debt to finance a project come when the project is unsuccessful. What if you don’t find renters? Or the sewer repair costs $50000? In that case, you don’t just lose your investment; the bank loses theirs also and you might not be able to borrow again on advantageous terms.

There are three general ways to finance a project, two of which we have already introduced. gives a simplified summary of the pros and cons of each method, adapted from Hayes (). But to summarize,

  • Self-finance Self-finance means to pay with your own money, or your business’s money.
  • Debt-financing Borrowing money from a bank, person or another institution. Lenders need to be paid back the borrowed amount plus interest.
  • Equity-financing Selling ownership of your business to fund business operations. Equity is another word for ownership in a company.
Table 4.1: Pros and Cons of financing methods
Pros Cons
Self-financing
You don't give away ownership If you can't afford it, you can't do it
Equity financing
You don't need to pay debt obligations
You don't have to pay back the money You give away some ownership
You share the risk with your investors Need to find investors
Debt financing
Less stress to make immediate profit Developing shares can be complicated and expensive
Your investments are more profitable (leveraging)
You keep ownership You pay interest on your loan
Interest on loans is tax-deductible You have additional risk if you are slow in paying it back
Your investments are more profitable (leveraging) You have to have credit established previously

4.2 Taxes

Taxes are “required payments of money to governments, which use the funds to provide public goods and services for the benefit of the community as a whole.” (). In the private sector, you need to account for tax payments when you consider the profitability of your projects. In the public sector, taxes provide funding and incentivize the behavior of private sector actors.

As a construction manager or engineer, you should rely on certified accountants to understand the details of the tax code, provide advice you on financial decisions, and/or file your taxes. However, a basic understanding of taxes will help you make wise business and infrastructure investment decisions. In this section, we will introduce basic tax principles related to businesses and infrastructure projects.

The tax a company pays is the product of the tax rate and the taxable income. (4.5)Taxes=Taxable Income×Tax Rate

Tax rate

A company has a 25% tax rate on $2 million in taxable income. What do they owe in taxes?


Beginning with , Taxes=Taxable Income×Tax Rate=2,000,000×0.25=500,000

Effective tax rates

In the US, most companies are required to pay both state and federal taxes. Federal tax code generally allows state taxes to be deducted from federal taxes, however. The effective tax rate a company pays combines both of these rates into a single number,

(4.6)Effective Tax Rate=State rate+(1State rate)×(Federal rate)

In this class, you should assume that tax rates given in problems are effective tax rates unless told explicitly otherwise. Common corporate effective tax rates are on the order of 25% to 40%, depending on industry and state.

Note that relies on a concept of taxable income, which is defined as

(4.7)TaxableIncome=RevenueExpensesInterestDepreciation+Capital Gains

Note how similar is to . In fact, taxable income is meant to be based on the returns of your project. The one exception is related to the change of value in capital assets — objects that hold value like property, equipment, or company stock.

  • If your asset loses value, you can deduct this loss from your taxable income. This called depreciation.
  • If an asset you owned for more than one year gained value, you have to pay taxes on these capital gains in the year you sold it.
Capital gains tax rates

Capital gains are usually taxed at a lower rate than income, for both corporations and for individuals. This incentivizes people to hold onto assets rather than selling them quickly, which can be bad for an economy. On the other hand, it can lead to distortionary behavior. Many company executives take their compensation in stock, and then pay a lower tax rate than if they were simply paid a salary.

In this class, we will just use a single effective tax rate.

Tax rate

Let’s go back to that house in Provo, but make it a little simpler. You buy it in January 2024 for $400k, earn $1,500 in rent each month, and pay $300 per month in utilities. You buy the house with a loan requiring 20% down and 7.5% interest. You sell the house 24 months later for $600k. How much do you owe on taxes in 2024 with a 28% effective tax rate? What about in 2025? Assume you make no payments on the mortgage.


Let’s start with . Our utilities payments count as expenses, and we do not have depreciation. The interest is with the proportion of the mortgage that we are paying interest on. So for one year, the taxable income is

TaxableIncome=RevenueExpensesInterestDepreciation+Capital Gains=(1500×12)(300×12)(0.075×0.8×400000)+Capital Gains=9,600+Capital Gains

In 2024 there are no capital gains because we still owned the house, and so had not realized any gains on it. In 2025, hower, we realized gains of $200k from selling a property that we originally bought for $400k. We can now calculate the tax owed in 2024 and 2025 using

TI2024=9,600+0=9,600Tax2024=96000.28=2,688TI2025=9,600+200000=190,400Tax2025=1904000.28=53,312

So, for 2024 you would potentially get a tax return, but your company could be on the hook for a big tax payment in 2025.

Investment or expense?

Note that includes expenses, but not investments. What’s the difference? Is a truck used for your business an investment or an expense? What about the diesel fuel used to run it? And the tires?

In general, the IRS classifies expenses that have a useful life of less than one year as expenses (), meaning that the truck itself is a capital investment. So the purchase price of the truck cannot be deducted from your taxes, but the loss of its value is deducted through deprecation. Gas, oil changes, tires, etc. to use the truck are a business expense. But instead of tracking all of these purchases, most companies simply use a per-mile allowance set by the IRS ().

What about new light bulbs for a rental property? What about a new roof for your rental property? Light bulbs can be considered an expense for standard maintenance. However, the IRS states that a new roof is an “improvement because it is a restoration of the building.”() Thus, it is a capital expenditure and you depreciate the cost of the new roof, rather than treating it as an expense.

As you can start to see, taxes are complicated and not always intuitive! Lesson: HIRE AN ACCOUNTANT! In this class, we will generally try to make it obvious which is which.

4.2.1 Depreciation

When you have a capital asset that depreciates in value, you can deduct the loss of that value from your taxable income as shown in . This encourages companies to invest in new equipment and facilities, because they can recover their costs over time. There are two general methods to calculate the depreciation in a given year:

  1. Straight-line depreciation assumes that the asset loses equal value in each year.
  2. Declining balance depreciation assumes that the asset loses an equal proportion of its remaining value in each year.

The sraight-line depreciation method assumes that the depreciation D in each year t is: (4.8)Dt=CSnn Where

  • Dt: depreciation in year t
  • C: initial cost
  • n: expected life of asset
  • Sn: expected salvage value in year n
Straight-line truck depreciation

Your firm purchases a $50k truck and intends to use it for five years, at which point you expect to sell the truck for $20k. Using a straight-line depreciation, what is the depreciation of the truck in year two?


Starting with ,

Dt=CSnn=$50,000$20,0005=$6,000

Thus, $30k of the truck’s value is depreciated over 5 years. The remaining $20,000 returns to us as a capital gain in the year we sell it.

The declining balance method relies on factors — shown in — to calculate the depreciation D in a given year t:

(4.9)Dt=C×dt

Where

  • C: initial cost
  • dt: depreciation rate for year {t}

Note that an asset with a ten-year depreciation timeline has eleven factors. This is because the factors assume you buy the asset in the middle of the year you buy it, and finish depreciating it halfway through the last year. Details on how the factors are calculated are in the expandable callout below.

Table 4.2: Declining Balance Depreciation Rates by Recovery Period  from Table in IRS ()
Recovery Period (Years)
Year (t) 3 5 7 10
1 33.33 20 14.29 10.00
2 44.45 32 24.49 18.00
3 14.81 19.2 17.49 14.40
4 7.41 11.52 12.49 11.52
5 11.52 8.93 9.22
6 5.76 8.92 7.37
7 8.93 6.55
8 4.46 6.55
9 6.56
10 6.55
11 3.28
Factors given as percent values.
MACRS declining balance truck depreciation

Your firm purchases a $50k truck, which has a 5-year recovery period. Using the MACRS 200% declining balance method, what is the depreciation of the truck in year two?


Starting with and using the factor in the five-year recovery column for year two:

Dt=C×dt=$50,0000.32=16000

Why is it called the declining balance method?

Sometimes businesses might be reluctant to invest in capital projects — buildings, warehouses, heavy equipment — because capital investment is not excluded from taxable income. This would slow down the economy as people work in less efficient spaces and with older machinery.

To encourage more capital investments by private industry, the US introduced the use of accelerated depreciation methods as part of the Modified Accelerated Cost Recovery System (MACRS). This allows businesses to recoup more of their capital assets through depreciation faster than the straight line method would allow.

The accelerated depreciation methods used in MACRS uses a form of the declining balance (DB) method. In the declining balance method, the depreciation is calculated as a fixed percentage of the remaining book value. For example, in the 200% declining balance method, percent depreciation is calculated as d=200%recovery period. For a 10-year recover period, d=200%10=20%. The depreciation is calculating as a percentage of the book value at the end of the previous year: Dt=d×BVt1().

compares the normalized book value, BVt/C, for the straight-line method, a true 200% declining balance method and the MACRS 200% declining balance method over a 10-year return period. Using a true declining balance method the book value will never reach zero. Thus, the MACRS 200% declining balance method switches to a straight-line method when the straight-line results in a larger depreciation than the declining balance method. In a 10-year recovery with a 200% declining balance, this occurs at age 6 as shown in .

Figure 4.1: Comparison of depreciation methods over 10 years using Half-Year Convention

The IRS () simplifies the depreciation calculations by providing tables of MACRS depreciation rates, dt,p, by different methods, years t, recovery periods p, and for the season when the asset began service. In addition, MACRS requires the book value to depreciate decrease all the way to $0 at the end of the recovery period for both straight-line and declining balance methods.

Note there are 11 years of depreciation factors for a 10-year recovery period in . This is because a half-year convention is used, meaning that we assume the asset is placed into service half-way through the first year (t=0.5 years), and ends half-way through the eleventh year (t=10.5 years) as shown in . The first and eleventh year depreciation factors are 50% smaller than if they were full years.

In this course we provide depreciation factors for the MACRS 200% declining balance method using the half-year convention in . All the homework and exam problems regarding MACRS will use this table. The IRS () dictates the recovery periods for different classes of assets. The recovery period will be given you in your homework and exam problems. In your career you will need to consult IRS () or a certified accountant.

MACRS

Technically, MACRS defines both the straight-line and various declining balance methods depending on rates of depreciation and the seasons when the asset enters service, but many sources — including FE and PE reference manuals — use MACRS to refer to one particular declining balance method only. As in, they define two methods, straight-line recovery and MACRS. Pay attention to the context of the problem!

An important concept related to depreciation is the book value of the asset, or how much an asset contribute’s to your company’s overall value in a particular year t. This is defined as

(4.10)BVt=Cn=1tDn

Where

  • BVt: Book Value in year t
  • C: initial cost
  • n: number of years in recovery period
  • Dn: depreciation in year n

Note that the book value is different from the market value — what the asset would likely sell for. For example, a the market value of a warehouse could appreciate from the purchase price due to rising real-estate prices, but for tax purposes the book value could decrease from the initial value, allowing the owner to take tax deductions on the decline in value of the warehouse. ().

Book value

For the $50,000 truck with a $20,000 salvage value and a 5-year recovery period, what is the book value of this truck at the end of year two by the straight-line recovery method? What about by the declining balance method?


For the straight line method, we have two years of depreciation using

Dt=CSnn=$50,000$20,0005=$6,000

so the book value of this, using :

BVn=Cn=0tDn=50000(6000+6000)=$38,000

In the declining balance method, we need to figure out the depreciation in year one and year two using :

Dt=C×dtD1=$50,0000.2=10,000D2=$50,0000.32=16,000

and the book value of this, using :

BVn=Cn=0tDn=50000(10000+16000)=$24,000

A big difference! If we had done a later year, the difference would not have been quite as large. Also, the declining balance method assumes there is no salvage value for the asset, which makes something of a difference here as well.

Which depreciation method should I use for my project?

The declining balance method will allow you claim larger deductions from your investments sooner. You can then use the money you save in taxes to recoup the costs of your investment, help pay off your loans of your capital investment, or invest in other projects.

If you have many other tax deductions in the earlier years of the recovery period, you may elect for one of the other methods that gives you larger tax deductions in later years of the recovery period.

4.3 Time Value of Money

Infrastructure is expensive to build, but it generates value and benefits over a long period of time. Because populations and economies grow, the opportunity cost of not building infrastructure is high. As a result, virtually all infrastructure is built using financial tools that harness something called the time value of money. These tools allow companies or governments to concentrate many years of revenues into a short period to build or purchase something expensive; at the same time, these tools allow investors to grow their monetary reserves and profit from the responsible development of society.

For the examples given in the first section, we generally limited our analysis years to one year returns. When considering projects over larger time periods, it is important to consider the time value of money.

Imagine you win a contest and are given two options. You can choose to collect your $1,000 prize today, or you can wait for ten years to get the same amount of money. Which option would you choose? There are at least three reasons you should take the money right away:

  • Risk There is a possibility that something bad could happen to your prize. Within the next 10 years, the company offering the prize could go bankrupt. Or you could die or become otherwise disqualified from claiming the prize.
  • Inflation Money loses value over time for a variety of reasons. $1000 will buy more goods and services now than it will in ten years.
  • Opportunity cost If you got the prize now, there are things you could do with it. You could spend the money on something that you would enjoy for the next ten years. You could also invest the money for ten years, during which time you would earn on that investment. Getting the prize later costs you these opportunities.

Money has value. Having money now is more valuable than having money in the future. This is called the time value of money. If I were to lend you money, I would want to receive not only the initial loan amount, but some payment to compensate me for the risk, inflation, and opportunity cost of making the loan. This payment is called interest, as we saw in . When financial analyses extend for more than period (years), calculating interest becomes slightly more challenging. There are two basic methods:

  1. Simple interest loans require a defined interest payment on the principal of the loan, or how much the loan is for.
  2. Compound interest loans combine the accrued interest with the unpaid principal at a particular compounding rate.

The amount we will pay in the future F using a simple interest loan over multiple periods is: (4.11)Fsimple=P+P×i×n where P is the principal, i is the interest rate (usually percent per year), and n is the number of interest periods (usually years).

Simple Interest

You borrow $50,000 to buy a truck with a simple interest loan and an annual interest rate of 10%. You will pay the interest and the complete principal back at the end of the loan. How much do you owe at the end of the 5 year loan?


We use the to calculate the interest accrued in each of the five interest periods.

Simple interestperiod=Principal×Interest rate=P×i=$50,000×0.10=$5,000

shows how the simple interest accrues in each period, with the interest on the principal adding to the loan balance but not to the principal itself.

Table 4.3: Loan Balance for 5-year Simple Interest Loan
Year Principal Interest Loan Balance
0 50000 0 50000
1 50000 5000 55000
2 50000 5000 60000
3 50000 5000 65000
4 50000 5000 70000
5 50000 5000 75000

So, the total payoff amount for the truck loan is $75,000.

While simple interest loans are easy to calculate, almost all investments and loans use compound interest.

Compound Interest

You borrow $50,000 to buy a truck with a compount interest loan, compounding annually at 10% per year. You will pay the interest and the complete principal back at the end of the loan. How much do you owe at the end of the 5 year loan?


shows the progress of this loan with compounding interest. Effectively, the primary difference is that we calculate the interest based not on the principal directly, but on the loan balance, which has the previous periods’ interest added into it. So the interest accruing in year 3 applies as I3=60,5000.1=6050.0

Table 4.4: Loan Balance for 5-year Compound Interest Loan
Year Principal Interest Loan Balance
0 0 0.0 50000.0
1 50000 5000.0 55000.0
2 50000 5500.0 60500.0
3 50000 6050.0 66550.0
4 50000 6655.0 73205.0
5 50000 7320.5 80525.5

We therefore will pay a total of $80,525.50, or about $5,500 more than we did with the simple interest loan.

The amount we will pay in the future F on a compound interest loan is a requires a little derivation. After one period, the compound interest formula looks just like the simple interest one, (4.12)F=P+P×i=P(1+i) If we have two periods, then we need to take the value from and multiply it by i, plus add another again for the new interest we add in year 1 (4.13)F=P(1+i)+P(1+i)i=P(1+i)(1+i)=P(1+i)2 If we keep doing this for n periods, we can derive a general equation (4.14)F=P(1+i)n

Compound interest formula

You borrow $50,000 to buy a truck with a compount interest loan, compounding annually at 10% per year. You will pay the interest and the complete principal back at the end of the loan. How much do you owe at the end of the 5 year loan?


This time, let’s use . We want the value we will pay in the future F, and we have P=50000,i=0.1,n=5:

F=P(1+i)n=50000(1+0.1)5=80,526

The same answer with a little less work.

4.3.1 Compounding Frequency

One consideration with compound loans is the compounding frequency, or how often the interest is applied into the total amount owed. Usually, the compounting frequency and the interest rate and the number of periods will all be the same: that is, n will be in years and i will be in percent per year, with annual compounding.

But that might not always be the case! Sometimes loans could compound more frequently than once per year. Many mortgages, for example, give a nominal interest rate per year, but actually compound monthly. In this case, becomes

(4.15)F=P[1+(i/k)]nk

with k the number of compounding periods in each n. You can see how this works: the nominal interest rate is divided across k periods, but the total number of periods multiplied to nk. i/k is referred to as the periodic interest rate.

Compounding frequency

The compounding frequency has a pretty important role in how much the loan is worth in the future. Let’s look at three situations where $1000 is loaned at 10% interest (i=0.1) for ten years.

  • Yearly compounding (k=1): $1000[1+(0.1/1)](110)=$2593.74
  • Monthly compounding (k=12): $1000[1+(0.1/12)](1210)=$2707.04
  • Daily compounding (k=365): $1000[1+(0.1/365)](36510)=$2717.91

shows the growth in the loan amount at each compounding period for different compounding frequencies. There is obviously a big difference between annual and monthly compounding, but there isn’t that much difference between monthly and daily, or daily and even hourly compounding. This suggests that there is a limit to this function as k increases.

Figure 4.2: Growth of loan value at different compounding frequencies.
Continuous compounding

It turns out that if you take the limit limkF=P[1+(i/k)]nk you can derive the equation for continuously compounding interest, (4.16)F=Pein

Using our new equation, we can find out how much money we will have after 10 years of continuously compounding the interest from our $1,000 invested at an interest rate of 10%.

  • Continuously: $1000e(0.110)=$2718.28

Notice that this value isn’t significantly more than the amount of interest earned by compounding the interest daily. As the number of compounding periods continues to increase, the interest earned in each period increases by a diminishing amount. However, remember that even when the difference may be small, the more frequent the compounding period, the more interest is generated.

You may see bank advertising their savings accounts with an Annual Percentage Yield (APY) instead of an interest rate (). The APY is an annual interest rate compounded once per year that would give you the same returns as the actual or period interest rate using the compound frequency of the bank.
So after one year (n=1), the future value of the investment using the APY and the actual interest rate and compounding frequency should be equal to each other:

Fannual=FactualP(1+APY)n=P(1+i/k)nkP(1+APY)1=P(1+i/k)k1 (4.17)APY=(1+i/k)k1

The APY allows investors to compare returns from investments that have different compound periods.

APY Example

A savings account has a nominal interest rate of 4.25%, and is compounded monthly. What is the APY?


Using ,

APY=(1+i/k)k1=(1+0.042512)121=0.0433=4.33%

4.4 Annuities and Gradients

Besides future and present values, two additional values might play a role in financial project planning and consideration. The first of these values is the annuity, A. This is the equal periodic payment that will repay a loan over time, or the equal period revenue expected from an investment. If we pay it all off in one period, then F=A. If it takes two periods, then the equation is F=A+A(1+i) including interest paid in the second period. Extending the full series n times and solving for A,

F=A+A(1+i)+A(1+i)2++A(i+1)n1=j=0n1A(1+i)jF(1+i)=j=1nA(1+i)jF(1+i)F=j=1nA(1+i)jj=0n1A(1+i)jF+FiF=A(1+i)nAFi=A[(1+i)n1]

This finally reduces to (4.18)F=A(1+i)n1i

To turn a future value into an equivalent annuity, we just take the inverse.

(4.19)A=Fi(1+i)n1

We could also derive equivalence between the annuity and its present value.

(4.20)P=A(1+i)n1i(1+i)n

(4.21)A=Pi(1+i)n(1+i)n1

Annual Mortgage

Assume that you are purchasing a home worth $200k with no down payment. The interest on the loan compounds annually at 4% interest and has a 30-year term. What is the monthly payment on the mortgage? How much will you pay on the home in total? What is the equivalent value of that money at the end of the mortgage.

We calculate the monthly payment as an annuity given a present value. So Using ,

A=2000000.04(1+0.04)30(1+0.04)301A=11,566per year/12A=964per month

The total amount paid is the sum of all annuities, or $346,981. The actual value of that amount is the future value of the annuity, or

F=11,566(1+0.04)3010.04F=648,680 ::::: {.callout-note icon=“false” title=“Annual Mortgage”}

Assume that you are purchasing a home worth $200k with no down payment. The interest on the loan compounds annually at 4% interest and has a 30-year term. What is the monthly payment on the mortgage? How much will you pay on the home in total? What is the equivalent value of that money at the end of the mortgage.


We calculate the monthly payment as an annuity given a present value. So Using ,

A=2000000.04(1+0.04)30(1+0.04)301A=11,566per year/12A=964per month

The total amount paid is the sum of all annuities, or $346,981. The actual value of that amount is the future value of the annuity, or

F=11,566(1+0.04)3010.04F=648,680

Monthly Mortgage

Usually, mortgages compound monthly. So, for a $200k with no down payment and 4% annual interest rate compounded monthly and a 30-year term, the payment ends up being

A=2000000.04(1+0.04/12)3012(1+0.04/12)30121A=955per month

This value is what it takes to turn an annual uniform payment into a present value. But it is also important to know how the bank handles each of these payments. In each month, you pay off the interest that accrues first. So, in the first month when you owe $200,000, your interest contribution is Monthly Interest1=2000000.04/12A=667dollars leaving 955667=288 to reduce your principal. As time goes by, the amount you pay to interest goes down, and the amount you pay to your principal goes up. Showing this is left as an exercise.

4.4.1 Gradients

The second value is a gradient, or an annuity that increases its value over time by a uniform amount G. That is if G=100, then G1=0,G2=100,G3=200,,Gn=(n1)G. This can happen if, for instance, you expect that a business in operation will grow in each period, or if you plan to pay a larger amount on your mortgage as your income increases. We won’t do the derivation of this value, but the equations are:

(4.22)P=G[(1+i)n1i2(1+i)nni(1+i)n]

(4.23)F=G[(1+i)n1i2ni]

(4.24)A=G[1in(1+i)n1]

Example

Maintenance on an old machine is $100 this year but is expected to increase by $25 each year thereafter. What is the present worth of five years of maintenance? Assume an interest rate of 10%.

This is an interesting problem because it involves both an annuity ($100 per year) and a gradient of $25 each year. The cash flow diagram looks like this:

We can then calculate the present value of each element separately and add them together,

P=G[(1+i)n1i2(1+i)nni(1+i)n]=25[(1+0.1)51(0.1)2(1+0.1)550.1(1+0.1)5]=172P=A(1+i)n1i(1+i)n=100(1+0.1)510.1(1+0.1)5=379

for a total present value of $551

In all of our equivalence equations to this point, we necessarily assume some end-point n time periods in the future. But what about the equivalent present value of a perpetual benefit? We may use this assumption when considering the worth of capital investments where we don’t know when the benefits will end; if we want to find the present worth of this endless series of payments, we can use a simple formula for capital worth

(4.25)P=Ai

4.4.2 Calculation Shortcuts

It is important to know that the equations we have discussed so far exist, and that they are not magical constructs banks designed to part you from your money. But the equations themselves are somewhat unwieldy and impractical, and they are certainly difficult to remember. There are two primary shortcuts that you should be aware of.

  1. Factor tables
  2. Preexisting or custom software functions

4.4.2.1 Factor Tables

On the Fundamentals of Engineering (FE) exam and the exams in this class, you will not have access to Excel or to a programmable calculator. It is impractical to type in every element of each formula repeatedly; you are bound to make several mistakes.

Notice though that each equation we have looked at is the product of a scalar (A, F, etc.) and some factor of the interest rate and the time period. Watch what happens when we take a set of present values increasing by factors of 10 at a constant interest rate and time period.

for(P in c(1, 10, 100)){
  # F = P * (1 + 0.1)^10
  print(ptof(P, i = 0.1, n = 10))
}
[1] 2.593742
[1] 25.93742
[1] 259.3742

Unsurprisingly, the future values are direct multiples of the present value. This means we could create a table that contains the factors for different interest rates and periods. A partial table for 2% interest is in , and a complete set of tables are in . The way to read these tables is as follows:

  1. Identify the table for the interest rate you are given.
  2. Determine which column of factors you need. You read F/P as “F given P”, so this is your column if you have been given a present value and wish to find the future value.
  3. Find the row in the table for the given number of periods. If F/P is your column and the number of time increments is 5, your value is 1.1041.
  4. Multiply the original given value by the value from the table. Keeping with the same example, if you were given 1,000 dollars for P, you multiply it by 1.1041 to find F = 1,104.10 dollars.
Table 4.5: Factor Table: i = 2.00%
n P/F P/A P/G F/P F/A A/P A/F A/G
1 0.9804 0.9804 0.0000 1.0200 1.0000 1.0200 1.0000 0.0000
2 0.9612 1.9416 0.9612 1.0404 2.0200 0.5150 0.4950 0.4950
5 0.9057 4.7135 9.2403 1.1041 5.2040 0.2122 0.1922 1.9604
8 0.8535 7.3255 24.8779 1.1717 8.5830 0.1365 0.1165 3.3961
10 0.8203 8.9826 38.9551 1.2190 10.9497 0.1113 0.0913 4.3367
25 0.6095 19.5235 214.2592 1.6406 32.0303 0.0512 0.0312 10.9745
50 0.3715 31.4236 642.3606 2.6916 84.5794 0.0318 0.0118 20.4420
Example

You will need $10,000 in 5 years, and you can invest at 2% interest. How much do you invest now? How much would you invest each year?

You wish to find the present value given a future value, so you want the P/F column. The factor for this column in the 2% table at 5 years is 0.906, so you have P=FP/F(0.02,5)P=10,0000.906=9,057

The second half of the question asks us to find the equivalent annuity given a future value, so we look up the A/F factor, which is 0.192.

A=FA/F(0.02,5)A=10,0000.192=1,922

4.4.2.2 Functions

In practice, you will probably use functions that pre-exist in Excel or that you code yourself into software that you write. The examples on this page use functions that I wrote in the R programming language. For example, we can write a function for that converts P to F, and then use that function to quickly find the future value for each of the compounding rates in the the example above:

#' Function to find F given P
#' @param P Present value
#' @param i Interest rate
#' @param n Number of periods
#' @param k Compounding iterations per period, default is 1
ptof <- function(P, i, n, k = 1){
  P * (1 + (i / k) )^(n * k)
}
for(k in c(1, 12, 365, 365 * 24)) {
  # print a message with how many times per year
  print(
    str_c("Compunding ", k, " times per year: ", 
  # 1000 for ten years at 10%, compounding k times per year
          ptof(1000, 0.1, 10, k), sep = "")
  )
}
[1] "Compunding 1 times per year: 2593.7424601"
[1] "Compunding 12 times per year: 2707.04149086224"
[1] "Compunding 365 times per year: 2717.90955457697"
[1] "Compunding 8760 times per year: 2718.26631329575"

In Excel, there are an array of functions that you can use. For example, the FV() function will compute the future value of an investment given either an initial value or a regular payment. That means, the FV function works both as and also as . The results and use of this function are shown in .

Figure 4.3: Excel FV function in use.

Provides a lookup table of factors and their Excel and Google Sheets function equivalents.

Table 4.6: Factors and Spreadsheet Functions
Factor Excel / Sheets Function
P/F PV(i, n, ,F)
P/A PV(i, n, A)
P/G Not included
F/P FV(i, n, , P)
F/A FV(i, n, A)
A/P PMT(i, n, P)
A/F PMT(i, n, , F)
A/G Not included

4.4.3 Financial Tools

Now that we have a basic understanding of the time value of money and the power of interest, we can discuss some of the tools that are often used to finance projects. These financial tools are based on the time value of money, and work by using the power of interest to raise the funding necessary for projects.

Financial tools differ based on how the loan is structured (interest, compounding), whether the project can bring in revenue while it operates, and when and how the loan is paid off. Each of these variables can be difficult to describe. A cash flow diagram is a chart that shows inflows and outflows of cash over time for a project or company, and can be a way to simplify these complex exchanges.

First, imagine that you have taken out a student loan of $10,000 at a 5% interest rate. You want to pay this back over the next 10 years, so you decide to pay it off by putting $1250 towards the loan every year until the final year, when you will pay it off in full. This cash flow can be represented with the diagram in .

Figure 4.4: Cash flow diagram for a student loan and repayment.

The diagram is set up by drawing a horizontal line representing the time over which the cash flow takes place. Intervals represent periods of time, in this case years, starting at 0 when you initially borrow the $10,000. Arrows that point up show cash inflows, like the $10,000 you borrowed initially. Arrows that point down show cash outflows, like the payments you make over the next 10 years to pay back the loan. Notice that larger amounts have larger arrows, although they don’t need to be exactly proportional. Another important point is that each arrow represents the net cash flow for each period of time. In some cash flow diagrams you may have inflows and outflows during the same period, but they can be added together and represented using just one arrow.

Note that the borrower and the lender will each have their own cash flow diagram, and that these diagrams will be symmetrical. Let’s look at a couple of examples of cash flow diagrams. Let’s look at the diagram for the bank that loaned you the $10,000, shown in . Because they lent the money, their cash flow diagram will be the opposite of yours.

Figure 4.5: Cash flow diagram for a student loan and repayment; lender’s perspective.

These are simple cash flow diagrams. It is possible to represent complicated funding and revenue schemes with cash flow diagrams. We already discussed loans and savings accounts in the previous section. Three additional basic tools are used to finance projects: mortgages, bonds, and sinking funds. We will discuss each of these in turn.

4.4.3.1 Mortgages

A mortgage is a loan for the purchase of property that uses the property as collateral. A bank or other investor gives a person or a company money to purchase a property (often a home). The property owner then makes regular payments to the bank to pay back the principal on the loan as well as the accumulated interest. If the owner is unable to make these payments, the bank can cancel the mortgage, seize the property, and resell the property to cover its losses. In the commercial world, mortgages allow the financing of large projects that would otherwise be too expensive to fund. They also allow people to buy houses that cost many times their annual salary and build real wealth.

Interest rates change for many reasons. Typically when the economy is doing well, interest rates rise to encourage people with money to invest it. When the economy is hurting, interest rates fall to encourage people to innovate or restructure their debts. So it might happen at some point that a person could obtain a loan for an existing mortgage at a lower rate than they are currently paying. By refinancing, they can take out a second loan at a lower interest rate to pay off the original loan, and then continue paying off the new loan at the lower interest rate.

Question

Is a mortgage a simple loan or a compound interest loan?

In a mortgage, you don’t accrue interest, because you pay all the accrued interest in each period. Because you don’t pay “interest on interest”, shouldn’t a mortgage be considered simple loan?

You might think so initially, but the answer is no. In a simple loan, the lender pays interest on the principal, but you don’t pay back the principal on a scheduled time-table like a mortgage. This is where the difference lies.

In a mortgage, the borrower pays the accrued interest and a fraction of the principal. Each mortgage payment is of equal value, with the initial payments mostly paying interest, and the last payments mostly paying principal. If you pay additional principal at the beginning of the loan, it has a compounding effect on the remaining mortgage payments. In each subsequent mortgage payment, more of your mortgage payment goes towards the principal and less goes towards interest. This has a compounding effect on the amount of interest you pay through the life of the loan.

For example, with a simple loan where you only pay interest and pay the principal at the end of the loan, you would pay twice as much interest if the length of the loan doubled (e.g. 15 years to 30 years). In a mortgage, you would pay more than 2.2 times as much interest with a 30-year mortgage compared to a 15-year mortgage with a 6% interest rate. (Note the relative difference in total interest between the mortgages depends on the interest rate and the length of the initial loan). See the Home loan homework question.

Short story, use the compound interest equations to calculate the monthly payments, present value, or future value of a mortgage.

In fact, if you had the option to either pay down the principal in your mortgage or save the money in an bank account with the same interest rate, compounding frequency, and time horizon, you would save the same amount of money either way. Thus, making additional early payments on a mortgage can save you substantial amounts of money later on.

4.4.3.2 Bonds

Bonds are agreements where a private investor loans a sum of money to a company or a government, and the company pays this principal (called the face value) back at the end date of the bond. The borrower also agrees to make regular interest payments (called the coupon) to the bond holder until the bond’s end date.

Because the interest doesn’t accrue, and the face value is not paid until the end date of the bond, a bond is a form of a simple interest loan. You can calculate the total interest you need to pay on a bond using .

It is possible for a bondholder to sell their bonds to other investors. This might be advantageous if interest rates increase, allowing an investor to buy bonds with higher payments. On the market, bonds can be described in two terms:

  • value: the present worth of all future bond payments, including the payback amount. This will not necessarily be the sale price of the bond, because other bonds on the market might have more or less of their value in the interest payments.
  • yield: the ratio of the annual interest payment to the bond price.

If an institution fails to pay its bondholders, the institution is considered in default, and the bondholders can force the institution into bankruptcy. Institutions that are more likely to default therefore must pay higher interest rates to attract investors, and institutions that are unlikely to default (like the United States Treasury) pay very low rates compared to their peers.

Bonds are an especially important way for governments to raise money from many investors. In the case of a mortgage, most banks have the capital necessary to issue loans for houses (even many houses). But it would be very difficult for a bank to gather enough money to make a loan that would build an interstate freeway. It would also be impossible for a bank to repossess the interstate if the Department of Transportation couldn’t pay back the loan. Hence the importance of trust.

A special kind of bond can happen when the infrastructure will generate revenue, such as for a toll road. In this case, the investors might buy a portion of the tolls collected from the facility in exchange for a lower interest payment or a lower payback amount.

Think

In revenue-financed bonds for toll roads, the forecasts of traffic engineers play a critical role in helping investors to set the terms of the bond. What might happen if the traffic forecasts are wrong?

Think

If municipalities don’t have enough money to pay for the infrastructure in the first place, how can they afford to pay off the face value of the bond at the end of the bond?

Municipalities use money from taxes to pay for the interest and put money aside to pay for the face value in a sinking fund (See ). Putting aside money to pay for interests and bond principal is called debt services (). The US government used 17% of the federal budget on debt services in 2024 ().

4.4.3.3 Sinking Funds

Sinking funds are used to put aside money for a future expense. A company often creates a sinking fund for the payment of bonds, or for the eventual repayment of a large debt. Sinking funds can also be a powerful tool in individual retirement. By setting aside a set amount of money every month, a person can eventually create a large sum of money that will gain enough interest to pay their living expenses and allow them to retire. Letting time and interest work for you and investing now is much efficient than trying to save in the future.

The United States Highway Trust Fund was originally created as a sinking fund. Gasoline tax revenues would fill the fund, and transportation infrastructure projects would be paid from the interest on the fund. Unfortunately, the federal gasoline tax was set at a particular level (18.4 cents per gallon in 1993) and was not indexed to inflation or any other metric. Politicians in both major parties have resisted raising the gasoline tax in the last 30 years. This means that the purchasing power of the gas tax revenues have eroded from inflation even while increasing fuel efficiency lowers revenue per vehicle mile and construction prices have increased. The Highway Trust Fund now operates more like a dedicated budget, with Congress periodically needing to appropriate funds from other sources to pay for highway and transit infrastructure.

Think

Is the current state of the Highway Trust Fund sustainable? Is that a problem? If not, what would be needed to make it sustainable?

4.5 Equivalence

introduced the idea that the future value of money F is different than its present value after interest and time have been considered. We can turn this equation around to get the present value of future money as well:

(4.26)P=F(1+i)n

Now we can convert Future cash flows to the present. It should be noted that i can also be referred to as the discount rate, because it represents the discount that needs to be applied to money from the future when converting it to present money. This means that money from the future is valued less than money in the present.

This is powerful because it allows us to translate complex cash flows defined with different interest rates and time frames into an equivalent present value.

Different people and organizations value time value of money differently. Also, the same people and organizations, will value time value of money depending on the investment. For example, investors will expect higher returns on more risky investments.

As we have talked previously, the reason to invest in a projects is to receive a return of benefits. If you are a developer, you want to build something that will generate income justifying the cost of construction. If you are building public infrastructure, the benefits might not be economic (although they could be). We will now consider definition of returns that considers the time value of money.

To do so, we need to be more precise about the timing of the returns. We will use the definition of returns in .

(4.27)Returnst=Asset Salet+RevenuetAsset PurchasetExpensestInteresttTaxest

Where

  • Rt: returns in year t
  • Asset Salet: The sale price of an asset
  • Asset Purchaset: the purchase of the asset, this includes outright purchase of the asset, downpayment of principal, the portion of your mortgage that goes towards paying principal, and the final loan payoff if you sell your asset before the end of the loan.

When is calculated over the liftime of the assets, then Δ(Asset Value=Asset saleAsset Purchase, and we obtain the earilier Returns equation in .

Because we often purchase an asset with a loan, we can separate the Asset purchase into the Loan down payment, Loan payment of principal, and the Loan payoff. The Loan payment includes both the payment of both principal and interest. This yields :

(4.28)Returnst=Asset Salet+RevenuetExpensestTaxestLoan down paymenttLoan paymenttLoan payofft

We will use these equations for calculating yearly returns in the next section.

4.5.1 Net Present Value

Using the time-value of money equations we learned in the previous section, and with a discount rate, we can find the net present value (NPV) of a project, or the current value of all future cash flows. If the NPV is positive, then the project will result in a positive return on investment. If it is negative, then the project will lose money over its life. The equation for the NPV is (4.29)NPV=t=0nRt(1+i)t

where * Rt: net returns at time t * i: interest / discount rate * t: period of time

Note that the 1/(1+i)t is the same as P/F(i,t), or the equivalence function to bring a future value to the present.

Example
t invested earned
1 1000 0
2 1000 100
3 0 200
4 0 400
5 0 600
6 0 600
7 0 600
8 0 500
9 0 300
10 0 100

Consider a project with the projected cash flow shown in the table above with amounts invested in the invested column and the amount earned in each year in the earned column. What is the NPV of this project with a 10% discount rate?

The first step is to calculate the present value of the invested and earnings columns. These columns are shown on the table below as pv_invested and pv_earned, respectively. For an example of how this table is calculated, the present value of the 1000 dollars we will invest in year 1 is P=FP/F(10%,1year)=10000.909=909 With the difference between the factor and the final value due to rounding error in the factor — I used a function to calculate the value above and all the values in the table below.

t invested earned pv_invested pv_earned
1 1000 0 909.09 0.00
2 1000 100 826.45 82.64
3 0 200 0.00 150.26
4 0 400 0.00 273.21
5 0 600 0.00 372.55
6 0 600 0.00 338.68
7 0 600 0.00 307.89
8 0 500 0.00 233.25
9 0 300 0.00 127.23
10 0 100 0.00 38.55
Total 2000 3400 1735.54 1924.28

The NPV is the difference between the present value of all earnings and the present value of all investments, which in this case is

NPV=1,9241,736=189

How much the project gains or loses is an important consideration beyond the binary win / lose scenario: every investment has an opportunity cost. If I invest in one project, I cannot invest in another. So we need some way to determine what the return is. I should look for investments that maximize my return.

Example

Consider a project with the same projected cash flow, but with a discount rate of 13%. What is the NPV of the project?

t invested earned pv_invested pv_earned
1 1000 0 884.96 0.00
2 1000 100 783.15 78.31
3 0 200 0.00 138.61
4 0 400 0.00 245.33
5 0 600 0.00 325.66
6 0 600 0.00 288.19
7 0 600 0.00 255.04
8 0 500 0.00 188.08
9 0 300 0.00 99.87
10 0 100 0.00 29.46
total 2000 3400 1668.10 1648.54

This table calculated the same way as above. The NPV is $-19.6.

4.5.2 Setting the MARR

This brings up the question of what discount rate should be used in NPV calculations, and how this discount rate is determined. Recall that the discount rate has to account for:

  • Risk: when you lend money, it might not always come back
  • Inflation: money will be worth less in the future
  • Opportunity Cost: you might be able to do something else with your money

In this way, the discount rate represents a Mimumum Acceptable Rate of Return (MARR). If a project’s returns are lower than the combined risk, inflation, and opportunity cost, then it is not a smart investment.

Example

In the previous examples, the interest rate was set first at 10%, and then at 13%. If these numbers represent the MARR for the investor, is the project a wise investment?

At 10% the NPV is positive, but at 13% it is negative.

Every actor in an economy including business owners, developers, investors, and individuals will have their own MARR when evaluating a project. Let’s unbundle the three elements of the discount rate: F=P(1+risk)n(1+inf)n(1+opp.cost)n

Because each of these rates individually is small (somewhere less than 10%), we can simplify this to a single rate that includes all three elements, (4.30)FP(1+risk+inf+opp.cost)n

We can also make this assertion because each element of i cannot really be definitively known. Having said that, there are reference points that can be used for these values. Governments regularly publish inflation statistics; using the long-run or recent short-run average inflation rate could be a good benchmark depending on the application. Further, government bonds for stable countries are seen as relatively risk-free investments; at the very least, the MARR for an investor should exceed the interest paid on those bonds. Finally, the market can show what investors are currently paying for bonds of equivalent risk.

Example

Your company plans to sell bonds to investors to raise revenue for a project. U.S. Treasury bonds have been recently selling at 5% interest, and are perceived to be a risk-free investment. A company with a similar risk profile recently sold bonds at 8% interest, but inflation forecasts have increased from 1% to 3%. How much interest should your company expect to pay on these bonds?

The MARR should include each element, but it is important to remember that the U.S. Treasury bonds already account for the existing inflation. Also, the interest paid by the reference company includes the opportunity cost, risk, and previous inflation forecast. So the MARR for investors is:

  • 5% opportunity cost and baked-in inflation
  • 3%-1% = 2% new inflation forecast
  • 8% - 5% = 3% risk relative to treasuries

Your company should expect to pay 10% interest on your bonds, because that will be the MARR of your investors.

When a company is considering the MARR for its own projects, it considers the cost of raising capital. If the return on the investment is less than the cost of raising capital, the company will lose money.

As mentioned in , businesses raise capital through debt or equity financing. Often they will use a combination of both debt and equity financing. One reason companies raise money from both methods is because the costs of debt financing tends to increase as they comprise a higher fraction of the cost of the project. For example, lenders may consider a project risky that is debt financed for more than 50% of the costs.

The cost of capital when it is a combined sources of capital is called the weighted average cost of capital (WACC). The WACC is calculated in .[Blank and Tarquin ()]

(4.31)WACC=(equity fraction)×(cost of equity capital)+(debt fraction)×(cost of debt capital)

Where the cost of debt capital is the interest rate on the debt. The cost of the equity is the expected rate of return of its company shares. By selling the shares, the company will not realized those returns, in other words, the equity costs is the opportunity cost of choosing to sell their equity.

WACC Example

A large hotel company is raising money to build a new hotel for $200 million dollars. They are planning to raise $120 million by selling stocks. The stocks for the company had an average annualized ROI of 9% over the last 4 years. The remainder of the capital will be financed with a bank loan with an annual interest rate of 6%. What is the weighted cost of capital (WACC) for this project?

WACC=(equity fraction)×(cost of equity capital)+(debt fraction)×(cost of debt capital)=120200×0.09+80200×0.06=0.6×0.09+0.4×0.06=0.054+0.024=0.078=7.8%

A company’s MARR should therefore be at least the value of the WACC. Of course, a company will not pursue every project with returns greater than its WACC, because doing so might expose the company to lots of risk, which would raise the MARR for investors that might buy the company’s stock. A company might set its MARR differently for projects of different sizes, with differing ranking and selecting criteria.

For an individual, the MARR should reflect inflation, risk, and the time that could be spent working on something else. In a very real sense, MARR is subjective.

4.6 Internal Rate of Return

In we looked at how to compute the return on investment for a one-year investement. But most projects in civil engineering and construction are not one-year investments. Often, people will build expensive infrastructure hoping to earn revenues over many years. It would be nice to know what the average rate of return on a project is when the costs and revenues occur in different years. It is also important to consider that because of the time value of money, dollar in different years have different values. In this section, we will define and use a measure called the internal rate of return (IRR) that accounts for these things.

The IRR of an investment is defined as the interest rate that makes the net present value zero. Or put another way, it is the interest rate at which all future earnings are equal to the investment.

Consider a simple project with only a present investment value P and future returns value F, as in . The net present value of this project is NPV=P+FP/F(i,n) Let’s solve this equation for the discount rate i when the NPV is zero: NPV=P+FP/F(i,n)0=P+F(1+i)nP=F(1+i)nFP=(1+i)n(FP)1/n=(1+i) which reduces to (4.32)i=(FP)1/n1 So, there is one particular value of i that effectively sets the future returns equal to the present investment value, with (F/P)n=1. This is the IRR.

Why is this value a rate of return, or a measure of return at all? Conceptually, it shows how much our initial investment grew over the course of our project, just like ROI is supposed to. But it works mathematically as well. We can add P/P and substract P/P (effectively adding 0) inside the parentheses, i=(FPPP+PP)1/n1=(FPP+1)1/n1 Now, let’s consider that our traditional ROI equation in can be redefined as ROI=FPP with the returns from our investment divided over the amount of the investment. This the value we have inside our rearranged ! (4.33)i=(ROI+1)1/n1 Effectively, i in this case is an annualized ROI (), with each year’s returns adjusted for inflation, risk, and opportunity cost.

IRR Example

You purchased shares in an engineering firm at $5.25 per share. After 14 years the shares are worth $25.66 per share. You pay no dividends or fees. What is the total ROI for this investment? What is the annualized ROI? What is the IRR?


First, we can calculate the traditional ROI over the 14-year period:

ROI=(returnsinvestment)=(Δ(Asset Value)Initial Value)=(Final ValueInitial Value)Initial Value)=($25.66$5.25)$5.25)=3.89

If we divide this directly by 14 years, we would get an annual ROI of 3.89/14=27%, but this value does not consider that the returns in some years are made of dollars that are worth less than the dollars in other years.

So, to calculate the internal rate of return we can put the 14-year ROI into : i=(ROI+1)1/n1=(3.89+1)1/141=(4.89)1/141=0.012=12%

Or we could work directly from : i=(FP)1/n1i=(25.665.25)1/141i=12%

IRR

You invest P into a savings account which yields a future value F after n years. The interest rate, i, on the savings account is compounded yearly. Which of the following terms best describes i?

  • Interest rate
  • APY
  • Annualized ROI
  • Internal rate of return

This is a tricky question. In this simple case i can correctly be defined by each of the terms. All of these values are the same in definition. However, only IRR is available when the cash flows get complex. Please note that sometimes the IRR is referred to as the rate of return or the ROI. For exams, and in this textbook, we will refer to the IRR as the IRR. The ROI will be used to refer to the return on investment over a period of time.

The benefit of IRR is that once we have calculated the NPV of a project — no matter how complex its costs and earnings — we now have a tool to immediately calculate the implied return from this project, and we don’t have to even know what the interest rate is, because it’s something we calculate in the problem.

For example, what if you make an investment P, in order to receive an annuity of A over the next n years. What is the rate of return of your investment? We can use P=A(1+i)n1i(1+i)n Unfortunately, is too complex to re-arrange to solve for i by algebra. Fortunately, there is another way to solve for i. We can construct the net present value of this cash flow, NPV=P+AP/A(i,n) and find the interest rate that sets NPV=0. We can do this by brute force — trying values until we get the right one — or by using optimization software included in spreadsheets or other programs.

We will now provide several examples on how to solve for the IRR with more complex cash flows.

IRR Example with Factor Tables

Margot decides to pursue a PhD degree in Civil Engineering while she is working. She pays upfront $30,000 for her tuition and books at the start of her program. She then earns an additional $5,000 per year for the next 5 years while a research assistant. In year 5, she successfully led a team to design an earthquake resistant bridge that was a direct outcome of her thesis. The President of her engineering firm gives her a bonus of $14,746.84. What is the IRR of her doctoral investment after 5 years? Is it 6%, 8%, or 10%?


To solve for IRR, we need to find the interest rate, i that yields an NPV = 0. Let’s draw a cash flow diagram of this problem to help us set up the NPV equation.

The upfront tuition and books are a present value P, the RA wages are an annuity A, and the bonus she gets is a future value F. So the NPV equation we need to solve is

0=P+AP/A(5,i)+FP/F(5,i) Let’s set up a table that will calculate this equation for different values of i. The final column, NPV is the equation above using the factors on that row. You can see that with a discount rate of 8%, the NPV is effectively zero, meaning that the IRR is very close to 8%.

i P A A/P FV F/P NPV
0.06 -30000 5000 4.2124 14746.84 0.7473 2081.5156
0.08 -30000 5000 3.9927 14746.84 0.6806 0.0017
0.10 -30000 5000 3.7908 14746.84 0.6209 -1889.4387

We can also solve this more precisely using a numerical solver. In this case, I can use the R optim function which works like goal seek.

# calculate NPV for different values of i
irr_example_fn <- function(i){
  NPV <- -30000 + atop(5000, i, 5) + ftop(14746.84, i, 5)
  abs(NPV) # find smallest NPV, positive or negative
}
# find value of i that makes this function 0, within bounds
o <- optim(0.06, irr_example_fn, method = "Brent", lower = 0, upper = 1)
o$par # This is the value of i that makes NPV 0
[1] 0.08000002

Sure is close to 8%.

And finally, here is a video showing how to solve the problem with goal seek:

The IRR is the rate of return of an investment. However, there are weaknesses. First, when solving for the IRR, sometimes your solver will not find the solution, which can also depend on your starting location. Second, under certain circumstances, the IRR for a given cash flow is not unique; e.g., a complicated cash flow might show a zero NPV at 2% and at 9%.

4.7 Project Assessment

In the previous section on returns, we looked at project evaluation largely as a binary consideration: is the IRR greater than the MARR? Or, is the NPV positive?

It is rare to only have one course of action in an investment. More typically, there are multiple different strategies or alternatives that you need to weigh against each other. In this section, we will discuss how to comparatively evaluate projects with different timelines, discount rates, and other variables.

4.7.1 NPV and IRR

NPV and IRR are both important methods to compare projects. These measures can sometimes identify different preferred alternatives, however this is not always the case as shown in the following example.

Example

Four different alternative highway maintenance regimens — plus a “do-nothing” alternative — are being considered. The present value of the long-run benefits (earnings) and costs (investments) are given in the table below. Calculate the NPV and IRR for each alternative. Assume a discount rate of 8%.

bc <- tibble(
  Alternative = c("Do Nothing", "A", "B", "C", "D"),
  Benefit = c(0, 24, 11, 41, 43),
  Cost = c(2, 7, 9, 17, 32),
)
tt(bc)
Alternative Benefit Cost
Do Nothing 0 2
A 24 7
B 11 9
C 41 17
D 43 32

This is a tricky problem, because there are two different discount rates: the discount rate for the analysis, and the IRR. The long-run benefits are a perpetual annuity, with a present value of A/i that is given in the problem. This implies that the benefit’s equivalent annuity value is A=Pi or Benefit×0.08. For alternative A,

Benefits(P)=Benefits(A)/iBenefits(A)=Pi=240.08=1.92

To get the IRR, we would need to find the discount rate at which the present value of the perpetual annuity is equal to the construction costs present value. Construction=Benefits(P)Construction=A/iirriirr=AConstruction=1.927=0.274

The NPV is much easier, and is simply the benefits minus the costs. For all options and with IRR given as a percent,

Alternative Benefit Cost IRR NPV
Do Nothing 0 2 0 -2
A 24 7 27.43 17
B 11 9 9.78 2
C 41 17 19.29 24
D 43 32 10.75 11

Based on IRR, the preferred alternative is A, but based on NPV the preferred alternative is C.

Think

Should you use NPV or IRR to prioritize projects?

That depends. If the projects are mutually exclusive (e.g. there are different alternatives for the same project, and you only can pick one alternative), then it is recommended to select the project with the largest net present value. ().

If the projects are independent from one another (e.g doing project A doesn’t stop you from doing project B) then a good approach is to rank the projects by the rate of return. (). First do the project with the best rate of return, if you have sufficient remaining funds, then do the project with the next best rate of return, and so on. Other methods to rank independent projects projects given budget constraints are discussed in ().

4.7.2 Benefit Cost Analysis

Private projects often will use the rate of return or the net present value to select between alternatives. This evaluates how much returns will return to the firm. For governmental or charitable non-profit organizations may want to pick a project that provides the most benefits to the public rather than the highest returns to the company. Benefit cost analyses (BCA) balances the benefits and costs of a project incurred to the public. Benefit cost analysis is also referred to as Cost-Benefit Analysis (CBA). BCA uses two different metrics, net benefits and benefit cost ratio (B/C). ()

4.7.2.1 Net Benefits

The net benefits are similar to the net present value, and are calculated as the present value of the benefits subtracted by the net costs, as shown in the equation .

Net Benefits=Present Value of BenefitsPresent Value of Costs Expressed mathematically as:

(4.34)Net Benefits=t=0nBt(1+i)tt=0nCt(1+i)t

Where

  • Bt: Benefits at time t
  • Ct: Costs at time t
  • i: discount rate
  • t: period of time

Benefits could include revenue, (such as tolls for a highway project) or funds saved (such as lower energy costs). Costs include the capital costs to build the project, operating and maintenance costs, and interest payments. With large multi-year infrastructure projects with long term impacts on the public, we account for the time value of money when calculating net benefits as shown in .

The benefit and the costs can be external to the organization building of funding the project. For example, the Federal Highway Administration (FHWA) lists the following as potential benefits and costs that can be included in an analysis of a highway project.()

  • Travel time (and the reliability of travel time)
  • Crashes
  • Fuel use
  • Vehicle operating costs
  • Emissions/air quality
  • Agency efficiency

In addition, the benefits could include lower costs due less risk of damage from a natural disaster (for a new flood levee or culvert). To include these external costs in a benefit-cost analysis, we need to be able to monetize these benefits and costs. As expected, many of the external or preventative benefits and costs are difficult to monetize. Economists have developed prices for some of these intangible costs, including the value of increased safety, by putting a value on human life.

Think

Is it ethical to put a price on a human life when evaluating infrastructure projects?

Imagine what would happen if we planned all projects to try to eliminate all risks to zero. Despite our best intentions, we can never completely reduce the risks of dying due to building failure, traffic crashes, or exposure to harmful pollutants. Even if we did, we would not accept the costs of such actions. e.g. if everyone traveled at a max speed of 20 mph, we would likely save lives from traffic accidents, but the cost of the extra travel time would be too high.

Federal agencies such as the Federal Highway Administration (FHWA), and the US Environmental Protection Agency (US EPA) use the value of the statistical life (VSL) in benefit cost analyses of projects, programs, and rule makings. By using the VSL, we can monetize the benefits of increased safety or decreased exposure to pollution, to then choose an acceptable amount of risk by balancing both cost and safety.

The US EPA describes VSL as ()

The EPA does not place a dollar value on individual lives. Rather, when conducting a benefit-cost analysis of new environmental policies, the Agency uses estimates of how much people are willing to pay for small reductions in their risks of dying from adverse health conditions that may be caused by environmental pollution.

For example, the US EPA used a VSL of $11 million dollars in a cost-benefit analysis of a proposed rule to lower emissions from heavy-duty trucks. ()

You can quantify the benefits from lives saved due to increased safety or less pollution exposure in terms of reduced risk from a baseline condition. The risk for a certain negative outcome (such as death or injury) is calculated using .

(4.35)Risk=number of people×probability×impact

Where

  • number of people: number of people potentially impacted by the negative outcome
  • probability: probability of the negative outcome occurring to each person
  • impact: the cost of the negative outcome occurring to a person

The benefit is then calculated as:

(4.36)Benefitalternative=RiskbaselineRiskalternative

4.7.2.2 Benefit Cost ratio

The second metric we use in benefit cost analyses is the benefit to cost ratio,  (B/C). The benefit cost ratio is similar to the ROI, in that it considers the benefits compared to the costs.

(4.37)Benefit Cost Ratio(B/C)=Present Value of BenefitsPresent Value of Costs

If the ratio B/C>1, then the project is feasible. If the B/C<1 the costs outweigh the benefits and the project is not recommended. If a project has a higher B/C ratio than another project, it could be more attractive than other alternatives.

Example

The present value of benefits and costs of four alternative highway maintenance projects (plus a “do nothing” alternative) are given below. Calculate the B/C ratios.

Alternative Benefit Cost B/C
Do Nothing 0 2 0.00
A 24 7 3.43
B 11 9 1.22
C 41 17 2.41
D 43 32 1.34

Using the B/C ratio, alternative A is the best option.

Do you use the Net benefits or use the B/C ratio in prioritizing projects? Both provide useful information, however you may want to consider using these metrics the same way we recommend using NPV and IRR. If you projects are mutually exclusive, you should pick the alternative that maximizes the net benefits. When you are evaluating many independent projects, you may want to prioritize the projects with the highest B/C ratio.

Note

In all of the examples we have covered, the benefits and costs of the projects were taken as given. In the real-world, almost all of the revenues and costs can only be estimated (save perhaps a loan payment which may be known). You should consider how confident you are in those estimates when conducting a financial or benefit cost analysis of a project. One way to do that is using an evaluation matrix discussed in the next section.

4.7.3 Evaluation Matrices

While benefit cost analyses are useful, decision makers often consider additional factors regarding large infrastructure projects. Large public projects have benefits and costs that occur on a wide spectrum of different dimensions. It can be difficult or impossible to monetize all benefits and costs in a BCA. Also, in a simple cost benefit analysis, we don’t consider social justice, or the equal sharing of costs and benefits (e.g. Who is benefiting the most from this project?, Who is most adversely impacted by this project?). We can use the triple-bottom line discussed in Chapter1 as a guide in making decisions, but within each of these dimensions can be multiple different variables that require consideration. A common method to put these variables into one decision making framework is by using an alternatives evaluation matrix. To create this matrix:

  1. Decide which elements of a project, in terms of benefits and costs or other outcomes need to be considered. This may involve public input.
  2. Develop a scoring system b for each element. This is often a score of 1 to 5 or a grade of A to F or some other categorical measure.
  3. Develop weights w for each element, again with public input.
  4. Calculate the weighted score of each alternative as Sa=ewebea where S is the total weighted score for the alternative, we is the weight of each element e, and b is the score of within that element for each alternative.

shows a project evaluation matrix from the Utah Transit Authority’s Point of the Mountain alternatives analysis. UTA has developed five different alternatives to provide high-frequency transit to Lehi and the site currently occupied by the Utah State Prison, using different combinations of light rail extensions and new BRT service. These five alternatives are each evaluated on a five-point scale applied to 19 different measures grouped into five general categories:

  • Transit System Performance
  • Access and Mobility
  • Land Use
  • Cost and Constructability
  • Natural and Built Environment
Figure 4.6: Point of the Mountain Transit Study alternatives analysis.

You can see in the figure how each alternative generally performs. The EW Connections alternative scores the best in terms of cost, but it performs poorly in terms of transit speed and reliability. The LRT East and BRT East alternatives have similar profiles, but the BRT option trades a bit of speed and reliability for a lower cost.

When conducted in this way, a number of different factors besides pure cost and benefit are allowed to contribute to the overall project evaluation. There is also a risk, however, that this method can become purely subjective if care is not taken to avoid pre-determining the outcome.

Unit Summary

The time value of money means that $100 now is worth more than $100 in the future because of risk, inflation, and opportunity cost. This makes interest a powerful tool in funding projects with things like mortgages, bonds, sinking funds, and toll-based financing. Cash flow diagrams provide an easy way to organize the cash flows of projects over long periods of time. Using equivalence equations for present value, future value, and annuities allows us to calculate the net present value (NPV) from a cash flow diagram, which determines if a project will be profitable. We must pick an appropriate discount rate in order to correctly calculate the present value of future cash flows and to meet our minimum acceptable rate of return (MARR). We can also calculate the internal rate of return for complex cash flows from infrastructure projects.

Ultimately, though, decisions cannot be based on finances alone. They must also incorporate costs and benefits that do not have monetary values, either by determining a value for them or by using a suitable weighting system for different categories. Sustainable infrastructure can only be achieved if all of these factors are considered.

  • annuity (A): a series of equal payments made over time
  • bond: financial tool in which an investor loans a sum of money to an organization, and the borrower pays annual interest on the loan until the end date of the bond, at which point they pay back the face value
  • book value: the initial cost of an asset minus total depreciation
  • cash flow diagram: a graphical display of cash inflows and outflows over time
  • compounding frequency: the frequency with which the interest on a loan is re-applied to the principal
  • depreciation: the value of an asset lost over time due to use, found using methods like straight-line or MACRS
  • discount rate: an interest rate used to determine the present value of a future cash flow
  • external rate of return (ERR): the discount rate at which the present value of investments is equal to the future value of earnings
  • factor tables: tool for converting cash flows (PV,FV,A,G) into equivalent time values of money
  • future value (FV): the equivalent future worth of a sum of money or series of payments
  • gradient (G): a series of equally increasing payments made over time
  • inflation: the increase in price for goods and services over time
  • interest: money paid by a borrower to a lender in exchange for the use of their money
  • internal rate of return (IRR): the discount rate that makes the NPV of a project equal to zero
  • minimum acceptable rate of return (MARR): the lowest rate of return that a project must earn in order to be worthwhile to an investor
  • mortgage: a loan to purchase property using that property as collateral, repaid in regular periodic amounts
  • net present value (NPV): the equivalent present value of all future cash flows
  • opportunity cost: the potential benefits that are lost when one option is chosen over another
  • present value (PV): the present worth of a sum of money or series of payments
  • project assessment: comparing projects using methods such as NPV, ROI, B/C, and incremental B/C
  • project evaluation matrix: a tool to compare several alternatives across an array of quantitative and qualitative criteria
  • refinancing: taking out a second loan at a lower interest rate to pay off an original mortgage
  • return on investment (ROI): the ratio of the equivalent annual earnings to the total investment
  • risk: the chance that an investment will be less profitable than expected, including the possibility of losing some or all of the original money
  • sinking funds: a fund where smaller amounts of money are put aside regularly to pay for some larger expense in the future
  • time value of money: the concept that money now is worth more than the same amount of money later because of risk, inflation, and opportunity cost
  • toll-based financing: loans to build infrastructure are repaid using future revenue from tolls and service fees
  • zoning: laws that specify what types of projects can be built in certain areas

Homework

Problem Set: Investments and ROI

HW 1: Investments and Returns

An engineering firm is considering investing in a renewable energy project that costs $750,000. Over the next 5 years, the project is expected to generate annual revenue of $200,000 per year. However, the operating and maintenance costs for the project cost $50,000 per year.

  1. Calculate the returns for one year.
  2. Calculate one-year ROI.
  3. Calculate the returns for five years.
  4. Calculate the five-year ROI
HW 2: Rental Property

You purchase a rental property in Provo for $600,000 at the end of 2022. For all 12 months of 2023, you rent out the home for $3,000/month. You pay an average of $500 dollars/month in property taxes and $400 dollars/month in utilities. You also pay for $30,000 of repairs during the year. At the end of 2023, you sell the investment property for $650,000.

  1. What are your returns?
  2. What is your ROI?
HW 3: Excavation

You own an excavation company. You are considering buying an additional excavator for $125,000 and hiring someone to operate it. With the excavator, you estimate your additional annual revenue and expenses to be:

Revenue Fuel Maintenance Insurance Operator Wages
$120,000 $10,000 $10,000 $15,000 $50,000
  1. Considering just the revenue and costs above, what are your first-year returns?
  2. What is the simple pay back period for the excavator? Provide the answer in years and months.
  3. What is the 1-year return on investment (ROI)?
HW 4: Excavation Loan

Now assume that you take out an equipment loan to pay for the excavator. In order to qualify for a reduced interest rate of 6%, you need to make a 20% down payment.

  1. What are your returns in the first year?
  2. What is your 1-year ROI?
  3. Compared with the previous problem, should you take out a loan for the excavator?
HW 5: Investments, Returns, and ROI

You are working as a project manager for a civil engineering firm, overseeing the development of a large residential subdivision. The project involves constructing 200 homes, and each home will require an investment of $500,000 for land acquisition, materials, labor, and infrastructure (including roads, water systems, and utilities). After completing the project, you estimate that the company will generate an average profit of $100,000 per home due to favorable market conditions.

  1. What is the total investment required for the entire subdivision?
  2. What will be the total returns from the project?
  3. Calculate the project’s ROI over the time period of the project.

Problem Set: Taxes and Depreciation

HW 6: Book values

A company purchases a bulldozer for $200,000 and expects a salvage value of $30,000 at the end of the 7-year recovery period. Using both the straight-line and declining balance depreciation methods, calculate the depreciation and book value of the asset at the end of each year of the recovery period. Which method will have a lower tax burden in year 6, all else equal?

HW 7: Excavator Depreciation

Reconsider the excavator problem in HW 4 (where you took out the loan), but include the depreciation of your excavator and the taxes you need to pay to operate. Assume that the excavator has a 10-year lifetime with a salvage value of $10,000, and use straight-line depreciation. Use a 33% effective tax rate.

  1. What is the annual depreciation value?
  2. Re-calculate the annual returns and the simple payback period.
  3. Re-calculate the 1-year ROI considering the excavator depreciation.
HW 8: A fleet of excavators

Your company purchased an excavator in 2019, 2021, and 2022; each excavator cost $125,000. What is the total book value of all of your excavators in 2025 by the declining balance method? Construction equipment has a five-year recovery period.

Problem Set: Time Value of Money

HW 9: Time value F from P

A $5,000 investment earns 6% per year. What will be the value of this investment in 15 years if:

  1. The investment is compounded annually?
  2. The investment is compounded monthly?
HW 10: Time value P from F

When you were born, your grandparents purchased shares in a mutual fund paying 8% interest per year compounded annually, hoping that this investment would pay for your college tuition (lucky!). Assuming you are at BYU for eight semesters beginning when you are 19, how much should they have invested?

Assumptions

This problem requires you to make assumptions. There is not a single correct answer as different assumptions can be valid. Document your assumptions, and show your work.

HW 11: Comparing F

Sarah and Brian both invest in a retirement fund. Sarah invests $15,000 at age 30, while Brian invests $40,000 at age 50. Both accounts earn 8% interest per year, compounded annually.

  1. How much each will they each have at age 65?
  2. How much would Brian need to invest at age 50 to have the same amount as Sarah by age 65?
HW 12: Simple Uncle Shark

You borrow $20,000 from your uncle to help pay for four years of college (because your grandparents didn’t buy you a mutual fund…). You agree to a simple interest loan with an annual interest rate of 6% on the remaining principal owed at the end of each year. Each summer in college (before the end of the year) you work in his company and earn $4,000 which you use to pay down the loan principal. You then pay the entire loan off with your first out-of college paycheck at the beginning of year 5.

  1. How much total interest do you pay your uncle over the course of the loan?
  2. What is the payoff amount?

Include a table like the one below tracking your loan (you might find it helpful to have other columns as well).

Year Principal Interest Loan Balance (End of Year)
1
2
3
4
HW 13: Compound Uncle Shark

Repeat the previous problem, but the loan is compounded annually. That is, the interest is calculated on the entire remaining balance rather than just the principal amount.

Problem Set: Annuities and Gradients

Tip

I recommend solving the problems in this problem set primarily with the factor tables in , so you can get used to using them.

HW 14: Car Maintenance

Frank’s parents give him an old car that will last for 10 more years as long as he keeps repairing it. The car needs $500 worth of repairs the first year, and the maintenance costs will increase by $50 each year afterwards. How much money does Frank need to invest now at an 7% interest rate to pay for the next 10 years of maintenance on the car? Draw a cash flow diagram as part of your solution.

HW 15: Stock Market

You decide to invest in the US stock market, which has a historic return of 10% per year.

  1. How much would you need to invest each year to have $1,000,000 by age 65 if you started saving at age 25?
  2. How much would you need to invest each year to have $1,000,000 if you started at age 45?
HW 16: Depreciation in the present

You buy an excavator for $125,000 which has a 5-year recovery period and you expect to salvage the excavator for $25,000. What is the present value of all of the depreciation expenses if you use a straight line depreciation and assume a 6% discount rate? Include a cash flow diagram in your answer.

HW 17: Home Loan

You are buying a home for $430,000. Your 30-year mortgage has a 6.28% annual interest rate (compounded monthly) and requires a 20% down payment to secure.

  1. What is the monthly payment? Recall that i/k is the periodic interest rate.
  2. What is the total amount paid?
  3. For each month, calculate the amount of the payment that goes to interest and the amount that goes to principal. Create a plot showing these amounts over the entire course of the loan.
Help

Each month, your monthly payment includes part interest and part payment on your principal. If you pay all the interest that accrues each month, then any amount left over from your monthly payment will apply to the principal.

Set up a spreadsheet or computer program that calculates the amount paid to interest and to principal in each month of the 30-year mortgage. You should include example calculations and the top few rows of the table in your homework submission, but do not need to include the entire 360-line spreadsheet.

Also: if you have done this correctly, you will pay off the loan with your last payment.

HW 18: Home Loan Payoff

Consider the same information as the previous problem. What happens if you are able to pay an additional $200 each month?

  1. After how many years do you pay off the mortgage?
  2. How much total money do you pay?
  3. How much money do you save compared to the previous problem?

It is not necessary to include the graph again.

Problem Set: Equivalence

HW 19: Water lines

You are considering signing a contract to install water lines in a development project with a 5-year construction timeline. You expect your annual costs to be $400,000/year. The developer provides two options for your company’s payment.

  • Option 1: The developer pays you $1,000,000 now (year 0), and $2,000,000 at the end of the project in 5 years.
  • Option 2: The developer pays you $4,000,000 at the end of the project (in 5 years).
  1. Draw/graph a cash flow diagram of both options.
  2. Assume your company uses an annual discount rate of 12%. Calculate the present value for each of the payment options.
  3. Which is the preferred option using the net present value (NPV)?
  4. What other financial considerations are there that are not expressed in the NPV?
HW 20: Construction Company Present Value

You are a project manager for a construction company, and you are evaluating the potential investment in a new piece of heavy machinery. The initial cost of the machinery is $150,000. You expect this machinery to generate additional annual revenues of $45,000 for the next 5 years. At the end of the 5 years, the machinery will have a salvage value of $10,000. The company’s expected rate of return for their investments is 8%.

  1. Calculate the Present Value of Future Revenues: Using the company’s expected rate of return of 8%, calculate the present value (P) of the additional annual revenues generated by the machinery over the next 5 years.

  2. Calculate the Present Value of the Salvage Value: Calculate the present value (PV) of the salvage value of the machinery at the end of 5 years using the company’s required rate of return of 8%.

  3. Calculate the Present Value of the Revenue and the Salvage Value: Combine the present value of the future revenues and the present value of the salvage value to determine the total present value (PV) of the revenues.

  4. Determine the Net Present Value (NPV): Calculate the net present value (NPV) of the investment by subtracting the investment cost of the machinery from the present value of the revenue and salvage value calculated in question 3.

  5. Evaluate the Investment Decision: Based on the NPV calculated in question 4, determine whether the company should proceed with the investment in the new machinery. Explain your reasoning.

HW 21: Air Conditioner

Alissa wants to install a new $9,000 air conditioning system. Because it is more energy efficient, the system would save $1,400 per year in electricity costs. Assume the air conditioner is installed in year 0, and savings begin with year 1.

  1. Without accounting for the time-value of money, what is the payback period?
  2. Assuming a discount rate of 7%, how long will it take for the air conditioning system to pay for itself? Assume the savings compound annually. Hint: Find the number of years where the net present value is 0. This problem can be solved in multiple ways: algebraically manipulating the formula to solve for n, using goal seek to change n, or plotting n vs. P in a table.
  3. Draw a cash flow diagram for each of the above parts. Make sure to label your axis and which diagram comes from which part.
HW 22: Bonds

Ben can buy a bond with a face value of $1,000 paying at 6% interest for five more years.

  1. Draw or graph a cash flow diagram for the bond.
  2. What is the present value of this bond if Ben’s personal discount rate is 5%?
  3. What is the present value at a 7% discount rate?

Note: to solve this problem, first draw the cash flow diagram for the bond. Then, determine the present value of the bonds using the different discount rates.

Problem Set: Internal Rate of Return

HW 23: Pavilion to rent

In 2019, you built a pavilion to rent for special events $15,000 and started operations in 2020. Each year you operate, you incur $100 in expenses. In 2020, you made no money because of the pandemic. But in 2021 you earned $1,000, and grew your business by an $1000 each year after (e.g. $2000 in 2022, $3000 in 2023, etc.). At the end of 2024, you sold the pavilion for $15,796.68.

  1. Draw a cash flow diagram of this project.
  2. Calculate the NPV of this investment given discount rates of 10%, 12%, and 18%.
  3. What is the IRR of this investment?
HW 24: Dock

You are considering building a new dock at a port. There are two options for the dock. Dock A is smaller, will cost $70 Million dollars, and will generate returns of $24 million dollars/year for the next 10 years. Dock B is larger. It will cost $170 Million dollars and generate $41 million dollars per year for the next 10 years.

  1. The port authority uses a discount rate of 8% to evaluate capital investments. What is the net present value of both options using the 8% discount rate?
  2. What is the internal rate of return for both options?
  3. Which dock would you recommend building? Why?
HW 25: Varying Incomes

In 2010, you made a $45,000 investment in new construction equipment, which you expected to generate revenue of $10,000 per year for the next ten years (2011 through 2020), on $3,000 of annual expenses. In reality, the revenue was the values in the actual column of the table below:

year expenses expected actual
2011 3000 10000 7000
2012 3000 10000 10000
2013 3000 10000 13000
2014 3000 10000 18000
2015 3000 10000 11000
2016 3000 10000 2000
2017 3000 10000 8000
2018 3000 10000 12000
2019 3000 10000 7000
2020 3000 10000 14000
  1. Calculate the IRR for the expected project as well as what actually happened. Did things go better or worse than what you expected?
  2. Comment on what might happen in 2016 if this project was financed through a bank.
HW 26: The Big Kahuna
Difficult problem

This problem ties together almost everything you have learned in this unit. When you understand how to solve this problem, then you should be well-prepared for the test and to solve related problems in your career.

Advice to solve: clearly read the problem, and take each element in steps. Set up a spreadsheet to track each year’s returns, taxable income, and any values used to calculate those elements. As always, include example calculations in your homework response, alongside a replication of your spreadsheet.

Your company is looking to build a new incinerator that will generate electricity by burning household waste and thereby diverting trash from landfills. Someone in your office recommended calling this incinerator “The Big Kahuna” and no one else had any better ideas.

Each year you operate, you will generate electricity worth $1.5 million, and incur expenses of $400,000. Your incinerator will go online halfway through 2026, and will stop operations at the end of 2035 (i.e., 2026 will only have half the revenue and half the expenses but 2035 will have a full year).

The incinerator costs $3 million dollars, and you will finance its purchase with a bank loan offered at 6.5% annual interest compounded annually and 20% down, paid back over the next ten years (down payment in 2025, payments starting in 2026).

Incinerators like this one have a seven-year recovery period using the MACRS declining balance method. You also expect to salvage the equipment for 500,000 at the end of 2035. You pay a corporate tax rate of 28% on your taxable income, and your company has a MARR of 12%.

  1. Calculate the NPV of this project using a 12% discount rate.
  2. Calculate the IRR of this project.
Range of answers

If you have done this problem correctly, you should get an NPV in the neighborhood of $2.5 Million with an IRR between 50% and 100%.

HW 27: Self-financing the Big Kahuna

When you are about to finance the loan, one of the members of your board calls you up and says he would rather the company self-finance the incinerator purchase, to keep the company out of debt. Is this a good idea?

Tip

The best way to solve this problem is to simply copy your spreadsheet from the previous problem, and change it so that the entire cost of the incinerator comes up front, and remove the finance payments. Calculate the NPV and IRR, and use that information to tell your board member what you think the company should do.

Problem Set: Project Assessment

HW 28: Arizona Traffic Projects

You are evaluating the profitability of different traffic projects for the Arizona Department of Transportation (AzDOT). You assume that these projects will last a long time, and for simplicity you assume that the benefits can be projected for perpetuity (forever). The construction costs, and the annual returns from each project are listed in the table below. Assume that construction occurs at age 0 of the project, and the returns occur starting in year 1 for perpetuity.

Project Construction Cost Annual Returns [M$] Present Value (Returns) Net Benefits B/C IRR
A 20 1.8
B 82 6.0
C 120 10.0
D 140 10.5

AzDOT uses a discount rate of 4% for all projects.

  1. Complete the table with these calculations. Show your work with an example calculation.
  1. Calculate the present value of the returns
  2. Calculate the net benefits
  3. Calculate the benefit/cost ratio
  4. Calculate the IRR (%)
  1. Assume that projects A through D are for different independent traffic projects throughout Arizona. Your supervisor asks you to recommend which projects should be built this year given a budget of $140 Million. Which project(s) do you recommend? Which financial metric did you use to develop your recommendation? Hint: See the “Think” box in .

  2. Assume that projects A through D are different alternatives for the same traffic project. This means that you can only do one of the projects. Again you have a budget for this project of $140 Million. Your supervisor asks you to recommend one project. Which financial metric do you recommend to use? Why? What are your net benefits?

HW 29: Traffic Engineer in Provo City

You are a traffic engineer for Provo City. You recently conducted a safety analysis of pedestrian crossings. One of the pedestrian crossings was identified as University Avenue between the old Provo High school and the BYU Indoor training facility.

The pedestrian fatality rate was estimated to be 0.01 fatalities per 100,000 pedestrians. You estimate that 200,000 pedestrians will use the pedestrian crossing per year. Assume that Provo City uses a value of a statistical life of $11,000,000.

You have developed two different proposals for the city. Option 1 is an elevated walkway, and Option 2 is an improved crosswalk with flashing lights. You have conducted a safety analysis of both options. Option 1 is the safest option, but the most expensive. Option 2 improves the safety, but is much less expensive. The lifetime of both projects is assumed to be 30 years.

Project Fatality Probability per 100,000 Pedestrians Construction Costs
baseline 0.0100 0
Option 1 0.0010 4,000,000
Option 2 0.0075 600,000
  1. Calculate the annual cost of the risk of pedestrian fatalities in dollars, assuming 200,000 annual pedestrians, estimated pedestrian fatality rates, and the value of a statistical life. From the baseline scenario, and the two proposals. Use the definition of risk found in
  2. Calculate the benefits for each of the two proposals as the reduced risk of pedestrian fatalities over the 30-year life-time of the pedestrian crossings. Calculate the benefits as the reduction in risk from the baseline scenario. Calculate the present value of benefits over the 30-year lifetime of the pedestrian crossings. Use a discount rate of 2%.
  3. Calculate the net benefits (Benefits – Construction Costs) for the lifetime of the project. Which project has the higher net benefits?
  4. Calculate the benefit/cost ratio for the lifetime of the project. Which project has a higher benefit/cost ratio?
  5. From the financial perspective, are both options worth considering? Why?
  6. Which project would you recommend? Why?

Problem Set: Multi-criteria


  1. For example, tractor units have a recovery period of 3 years. Vehicles have a recovery periods of 5 years. Office furniture, railroad tracks, and natural gas lines are 7 years, land improvements, electric transmission properties are 15 years. Water treatment and water distribution properties are 25-years. As you can see the recovery periods only seem somewhat related to the actual life-time of the assets.()↩︎

  2. There are also formulas for gradients that grow by less than a uniform amount. We will not cover these in this class↩︎

  3. You can also see this as F/P=(1+i)n, where the factor you want is isolated by the division.↩︎

  4. There are many more tools than can be listed here, and these descriptions are perhaps dangerously oversimplified. But this gives a decent overview for undergraduate engineers.↩︎

  5. A complete discussion of macroeconomic policy in setting and governing interest rates including the role of central banks is outside the scope of this class and the expertise of your instructor.↩︎

  6. Example taken from Martland ()↩︎

  7. This isn’t how PhDs work in engineering, where your tuition is usually paid by your research grants.↩︎

  8. This is sometimes called a Kepner-Tregoe (KT) matrix after the authors who proposed it as a rational process for decision making ().↩︎

  9. When we conduct a lifecycle analysis, shouldn’t we calculate the future value of cost and benefits to account for inflation, and then discount it back to the present value? In other words, if a VSL is worth $11 million today, shouldn’t it be worth even more in the future? The White House’s guidance on conducting lifecycle analysis recommends using constant-dollar values for future costs, and use a discount rate that has the inflation effect removed, called the real discount rate. The nominal discount rate is an estimate of the time-value of money, including the impact of inflation. For regulatory analysis, the White House recommends estimating the nominal discount rate from US treasury returns (). The real discount rate is calculated by subtracting the impact of inflation rate from the nominal discount rate. For example, if the nominal discount rate is 4%, and inflation is 2%, then the real discount rate is approximately 2% (See ). The net present value will be the same if your future costs include an inflation rate of 2%, and you discount using the nominal rate of 4%, as a case where future costs are expressed in constant-dollars, and you discount back to the future using the 2% real discount rate.↩︎