Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Calculate the present value of a 5-year increasing quarterly payable annuity immediate that has an initial payment of $50 and has an annual effective interest

Calculate the present value of a 5-year increasing quarterly payable annuity immediate that has an initial payment of $50 and has an annual effective interest rate of 8%. I have to do the problem through excel (my work in picture). The answer is supposed to be 2340.125. Can someone explain what I am doing wrong? Thanks.image text in transcribed

A F 6 B C D E Quarter Payment Discount Factor Present Value 1 50 0.980392157 49.01960784 2 50 0.961168781 48.05843906 3 50 0.942322335 47.11611673 4 50 0.923845426 46.1922713 5 100 0.90573081 90.57308098 6 100 0.887971382 88.79713822 7 100 0.870560179 87.05601786 8 100 0.853490371 85.34903712 9 150 0.836755266 125.5132899 10 150 0.8203483 123.052245 11 150 0.804263039 120.6394559 12 150 0.788493176 118.2739763 13 200 0.773032525 154.606505 14 200 0.757875025 151.5750049 15 200 0,74301473 148,602946 16 200 0.728445814 145,6891627 250 0.714162562 178.5406406 18 250 0.700159375 175.0398437 19 250 0.68643076 171.6076899 250 0.672971333 168.2428333 2323.545302 17 20

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

Introductory Econometrics For Finance

Authors: Chris Brooks

4th Edition

110843682X, 9781108436823

More Books

Students also viewed these Finance questions

Question

List the four steps in the model for giving praise.

Answered: 1 week ago

Question

List the criteria for setting objectives.

Answered: 1 week ago

Question

Describe four content motivation theories.

Answered: 1 week ago