Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please explain the annuity payment on excel. Formulas provided but answer is wrong. 32. You are going to pay $100 into an account at the

image text in transcribedPlease explain the annuity payment on excel.

Formulas provided but answer is wrong.

32. You are going to pay $100 into an account at the beginning of each of the next 40 years. At the beginning of the 41st year you buy a 30 year annuity whose first payment comes at the end of the 41st year (the account pays 12%). How much will you receive at the end of the 41st year (i.e. the first annuity payment). Round to nearest $100. a. $93,000 b. $7,800 c. $11,400 d. $10,700 PMT 100 nper 40 r 0.12 $85,914.24 =FV(C13,012,-C11,,1) ($10,419.98) =PMT(C13,41,86000,0,0)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Day Trading Strategies And Risk Management

Authors: Richard N. Williams

1st Edition

979-8863610528

More Books

Students also viewed these Finance questions