Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

PLEASE SHOW WORK AND EXCEL EQUATIONS Elliot makes $200,000 a year and pays 28% taxes on $150,000 and 25% on his remaining salary. His expenses

PLEASE SHOW WORK AND EXCEL EQUATIONS

Elliot makes $200,000 a year and pays 28% taxes on $150,000 and 25% on his remaining salary. His expenses are

$140,000 (per year). He wants to invest a fixed amount EVERY day into an investment fund for 5 years and he hopes

to get a 10% return. (20 PTS)

a. What is the maximum amount he can invest every day? (5 PTS) (Find the annual investment amount and

divide by 365).

b. What will be the worth of his portfolio after 5 years? (5 PTS)

c. After 5 years, Kassidys income increases to $250,000. He wants to reinvest for another 5 year, but this time,

his return will be 8% and his expenses have increased by 15%. What will be the worth of his portfolio after 5

years (total of 10 years)? (5 PTS)

d. What will the Present Value of his portfolio, assuming a 9% discount rate and NPER is 10 years? (5PTS)

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

Strategic Public Finance

Authors: Stephen Bailey

1st Edition

0333922212, 978-033392221

More Books

Students also viewed these Finance questions

Question

=+a) How does this model compare to the one in Exercise 39?

Answered: 1 week ago