Martinakom

Not Rated (0)

$12/per page/Negotiable

About Martinakom

Levels Tought:
Elementary,Middle School,High School,College,University,PHD

Expertise:
Accounting,Applied Sciences See all
Accounting,Applied Sciences,Architecture and Design,Biology,Business & Finance,Calculus,Chemistry,Computer Science,Geology Hide all
Teaching Since: Jul 2017
Last Sign in: 399 Weeks Ago
Questions Answered: 5023
Tutorials Posted: 5024
Category > Business & Finance Posted 09 Aug 2017 My Price 4.00

Please show how to set this problem up in excel

Elliot makes $300,000 a year and pays 25% taxes on $150,000 and 30% on his remaining salary. His expenses are $110,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 12% return. **Please show how to set this problem up in excel** 

(a.) What is the maximum amount he can invest every day? Instructions say it is this found by dividing the annual investment amount by 365.

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

(c.) After 5 years, Elliot's income increases to $350,000. He wants to reinvest for another 5 years, but this time, his return will be 10% and his expenses have increased by 15%. What will be the worth of his portfolio after 5 years (total of 10 years)? 

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

Answers

Martinakom
Not Rated (0)
Status NEW Posted 09 Aug 2017 02:08 PM My Price 4.00

Hel-----------lo -----------Sir-----------/Ma-----------dam----------- Â-----------  -----------Tha-----------nk -----------you----------- fo-----------r y-----------our----------- in-----------ter-----------est----------- an-----------d b-----------uyi-----------ng -----------my -----------pos-----------ted----------- so-----------lut-----------ion-----------. P-----------lea-----------se -----------pin-----------g m-----------e o-----------n c-----------hat----------- I -----------am -----------onl-----------ine----------- or----------- in-----------box----------- me----------- a -----------mes-----------sag-----------e I----------- wi-----------ll -----------be -----------qui-----------ckl-----------y

Not Rated(0)