• Wrong document? Swap it for free
  • Written by students who passed
  • Immediately available after payment
  • Read online or as PDF
Sell
Where do you study
Your language
Document preview thumbnail
Preview 2 out of 10 pages
Exam (elaborations)

Financial Modeling Exam 1 Questions and Answers 100% Pass

Document preview thumbnail
Preview 2 out of 10 pages

Financial Modeling Exam 1 Questions and Answers 100% Pass The 3 equivalent ways of calculating the present value of a single cash flow are: - 1. PV formula 2. PV function 3. PV timeline The effect of future value of a single cash flow when you increase the PV - an increase in the FV The effect of future value when you increase the discount rate - an increase in FV The effect of future value when you increase the number of periods - an increase in the FV Fully explain the formula used for calculating the FV of each cash flow - Each cash flow is compounded at the Discount Rate for the remaining periods What is the name of the term that the Present Value is divided by to get the Payment. Why does this formula give the Payment amount? - Present Value Interest Factor of 2Katelyn Whitman, All Rights Reserved © 2025 Annuity. APV = PMT X PVIFA. So, dividing by the Present Value Interest Factor undo's the product, and gives you the PMT. Show the formula for calculating the Annuity Present Value using the Annuity Future Value, Discount Rate, and # of Periods in Excel Notation - APV = AFV/(1+r)^t State the effect of increasing the payment amount on the APV and AFV - APV = increase in FV AFV = increase in FV Can the constant discount rate method be used to calculate NPV in the general case where the discount rate changes over time? Why/Why not? - No, because the NPV function & constant discount formula only allow for one constant discount rate. Fully explain the NPV function used to calculate the NPV in cell b21 - The NPV function in Excel assumes that Year 0 cash flow occurs at the end of the year instead of the beginning, so you add it to the NPV of the remaining years using the NPV function. The NPV function takes the cash flows from each year, discounts it by the nominal discount rate (which is found by compounding the inflation rate & the real discount rate) and summing them up (including the initial investment) Is the NPV of the project shown acceptable for investment? Why/Why not - A project is acceptable if the NPV is positive 3Katelyn Whitman, All Rights Reserved © 2025 If we add the inflation rate and the real discount rate to get the nominal discount rate, how will it be different from the formula in b9? - It won't give us the effect/measurement of the increase in the real discount rate due to inflation Why is the coupon bond yield to maturity close to, but not exactly equal to, the yield to maturity of the four-year treasury strip? - Because the yield of the coupon bond is a weighted average of the yields for each of the 8 periods. The biggest cash flow is on the maturity date, and the biggest weight in the weighted average is on that date. So, it's closest to the yield at the maturity date. But now the same. State whether the EAR convention results in a higher or lower bond price than the APR convention in and give the reason for this. - higher bond price because it is a lower discount rate, which from the laws of discounting cas

Content preview

Financial Modeling Exam 1 Questions
and Answers 100% Pass


The 3 equivalent ways of calculating the present value of a single cash flow are: - ✔✔1.

PV formula


2. PV function


3. PV timeline


The effect of future value of a single cash flow when you increase the PV - ✔✔an

increase in the FV


The effect of future value when you increase the discount rate - ✔✔an increase in FV


The effect of future value when you increase the number of periods - ✔✔an increase in

the FV


Fully explain the formula used for calculating the FV of each cash flow - ✔✔Each cash

flow is compounded at the Discount Rate for the remaining periods


What is the name of the term that the Present Value is divided by to get the Payment.

Why does this formula give the Payment amount? - ✔✔Present Value Interest Factor of




Katelyn Whitman, All Rights Reserved © 2025 1

, Annuity. APV = PMT X PVIFA. So, dividing by the Present Value Interest Factor undo's

the product, and gives you the PMT.


Show the formula for calculating the Annuity Present Value using the Annuity Future

Value, Discount Rate, and # of Periods in Excel Notation - ✔✔APV = AFV/(1+r)^t


State the effect of increasing the payment amount on the APV and AFV - ✔✔APV =

increase in FV


AFV = increase in FV


Can the constant discount rate method be used to calculate NPV in the general case

where the discount rate changes over time? Why/Why not? - ✔✔No, because the NPV

function & constant discount formula only allow for one constant discount rate.


Fully explain the NPV function used to calculate the NPV in cell b21 - ✔✔The NPV

function in Excel assumes that Year 0 cash flow occurs at the end of the year instead of

the beginning, so you add it to the NPV of the remaining years using the NPV function.

The NPV function takes the cash flows from each year, discounts it by the nominal

discount rate (which is found by compounding the inflation rate & the real discount

rate) and summing them up (including the initial investment)


Is the NPV of the project shown acceptable for investment? Why/Why not - ✔✔A

project is acceptable if the NPV is positive




Katelyn Whitman, All Rights Reserved © 2025 2

Document information

Uploaded on
January 19, 2025
Number of pages
10
Written in
2024/2025
Type
Exam (elaborations)
Contains
Questions & answers
$12.99

Wrong document? Swap it for free Within 14 days of purchase and before downloading, you can choose a different document. You can simply spend the amount again.
Written by students who passed
Immediately available after payment
Read online or as PDF

Seller avatar
Reputation scores are based on the amount of documents a seller has sold for a fee and the reviews they have received for those documents. There are three levels: Bronze, Silver and Gold. The better the reputation, the more your can rely on the quality of the sellers work.
KatelynWhitman
3.6
(260)
Sold
1261
Followers
485
Items
43877
Last sold
1 day ago




Why students choose Stuvia

Created by fellow students, verified by reviews

Quality you can trust: written by students who passed their tests and reviewed by others who've used these notes.

Didn't get what you expected? Choose another document

No worries! You can instantly pick a different document that better fits what you're looking for.

Pay as you like, start learning right away

No subscription, no commitments. Pay the way you're used to via credit card and download your PDF document instantly.

Student with book image

“Bought, downloaded, and aced it. It really can be that simple.”

Alisha Student

Working on your references?

Create accurate citations in APA, MLA and Harvard with our free citation generator.

Working on your references?

Frequently asked questions