Other
need help?
- Course
- Financial analysis (MGT105)
it is an excel sheet in which finance questions are solved with formulas
[Show more]
Seller
Follow
Content preview
1. A company’s 2005 sales were $10 million. If sales grow at 8% per year, how large will they be in 8 years?present value $10
period 8
rate 8%
future value $18.51 the future value of the company in 8 years will be $18.51
2. Suppose a government bond will pay $1,000 three years from now. If the going interest rate on 3‐year government bon
future value $1,000
period 3
rate 4%
present value $889.00
3. The bank offers to sell you a bond for $613.81. No payments will be made until the bond matures 10 years from now, at
bonds $613.81
future value $1,000
period 10
interest rate 5%
4. Nike corporation earnings per share in 2005 were $4, and its growth rate during the prior 5 years was 9% per year. If tha
present value -$4
period 5
rate 9%
future $8.00
period 8.04
5. You have a chance to buy an annuity that pays $1,000 at the end of each year for 5 years. You could earn 6% on your mo
payment $1,000
period 5
rate 6%
future value $4,212.36
6. Suppose you inherited $200,000 and invested it at 6% per year. How much could you withdraw at the end of each of the
present value $200,000
period 15
rate 6%
period terms in months $20,592.55
7. You are buying your first house for $220,000, and are paying $30,000 as a down payment. You have arranged to finance
, present value $190,000
period 360
rate 0.58%
paymeny $1,264.02
8. Suppose you have to invest $15,000 at an interest rate of 3.5% (compounded quarterly) for a period of 5 years. What w
present value $15,000
period 5
rate (compounded quarter 3.5%
number of period 20
future value $29,846.83
9. You have $900 to invest today. In how many years will it double if you invest it at an interest rate of 11% compounded a
present value $900
rate 11%
future value $1,800
period 6.64
10. Suppose you want to buy a home after 3 years and you will need $15,000 for that. You open a savings account and dep
future value -$15,000
interest rate 4.50%
period 3
time period total 36
account deposit -$2,000.00
monthly payment $449.45
11. You are planning for an early retirement, so you decide to invest $5,000 per year, starting at age 23. You plan to retire
future value $1,000,000
annual investment $5,000
rate 8%
period 36.8136046788
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller tehsintoliwala. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for CA$17.39. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
76449 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now