For each of the following annuities, calculate the annual cash flow. (Enter roundedanware adirected, but do not use rounded numbers in intermediate calculations.2nswers to 2 decimal places (e.g., 32.16).):YearsCash Flow Present ValueInterest Rate$36,80027,500145,000215,00011%68815620

Question
Asked Sep 19, 2019
43 views
For each of the following annuities, calculate the annual cash flow. (Enter rounded
anware adirected, but do not use rounded numbers in intermediate calculations.
2
nswers to 2 decimal places (e.g., 32.16).):
Years
Cash Flow Present Value
Interest Rate
$
36,800
27,500
145,000
215,000
11%
6
8
8
15
6
20
help_outline

Image Transcriptionclose

For each of the following annuities, calculate the annual cash flow. (Enter rounded anware adirected, but do not use rounded numbers in intermediate calculations. 2 nswers to 2 decimal places (e.g., 32.16).): Years Cash Flow Present Value Interest Rate $ 36,800 27,500 145,000 215,000 11% 6 8 8 15 6 20

fullscreen
check_circle

Expert Answer

Step 1

We can find the annual payment using PMT function of excel. The PMT function works with following inputs: PMT (Rate, Nper, -PV, FV) where

Rate =  Interest rate per period

Npe...

Want to see the full answer?

See Solution

Check out a sample Q&A here.

Want to see this answer and more?

Solutions are written by subject experts who are available 24/7. Questions are typically answered within 1 hour.*

See Solution
*Response times may vary by subject and question.
Tagged in

Business

Finance

Time Value

Related Finance Q&A

Find answers to questions asked by student like you

Show more Q&A add
question_answer

Q: A financial planner is examining the portfolios held by several of her clients. Which of the followi...

A: The standard deviation of portfolio represents how much the rate of return of a portfolio varies aro...

question_answer

Q: Assuming that the rates of return associated with a given asset investment are normally distributed;...

A: a) Calculation of standard deviation:Standard deviation is 0.3516.Standard deviation can be derived ...

question_answer

Q: In 2011, an 1880-O Morgan silver dollar sold for $13,113. Required: What was the rate of return on t...

A: Calculation of rate of return: Rate of return on investment is 7.51%.Excel spread sheet:

question_answer

Q: Digital Organics (DO) has the opportunity to invest $1.06 million now (t = 0) and expects after-tax ...

A: Calculation of Total PV of Interest Tax Shield:Excel Spreadsheet:

question_answer

Q: You have developed data which give (1) the average annual returns of the market for the past five ye...

A: Computation of Historical Beta for Stock A and Stock B:For the computation of Historical Beta, it is...

question_answer

Q: Why should a real estate listing contract be in writing and what are the essential elements of a lis...

A: Real estate contracts refer to legal aggreement between different parties. It is enforceable by law ...

question_answer

Q: A 25-year annuity was purchased with $225,000 that had accumulated in a RRSP.  The annuity provides ...

A: This question is based solved using Excel functions:PMT: Tells us monthly mortgage payment on a loan...

question_answer

Q: Phil makes and sells rugs at his roadside stand. His monthly fixed cost for owning the stand is $150...

A: Phil's fixed cost = $1500Phil's total cost when he sells 12 rugs = $1548Phil's total variable cost w...

question_answer

Q: Patterson Brothers recently reported an EBITDA of $10.5 million and net income of $3.0 million. It h...

A: Calculate the earnings before tax (EBT) as follows: