100% satisfaction guarantee Immediately available after payment Both online and in PDF No strings attached
logo-home
need help? $12.49
Add to cart

Other

need help?

 4 views  0 purchase
  • Course
  • Institution

it is an excel sheet in which finance questions are solved with formulas

Preview 2 out of 7  pages

  • April 20, 2021
  • 7
  • 2020/2021
  • Other
  • Unknown
avatar-seller
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

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

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

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 $12.49. You're not tied to anything after your purchase.

Can Stuvia be trusted?

4.6 stars on Google & Trustpilot (+1000 reviews)

56326 documents were sold in the last 30 days

Founded in 2010, the go-to place to buy study notes for 14 years now

Start selling
$12.49
  • (0)
Add to cart
Added