Elliot makes $300,000 a year and pays 25% taxes on $150,000 and 30% on his remaining salary. His…

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?

InputAnnual salary25% tax portion30% tax portion25% tax30% taxAnnual expensesYears investmentReturnNumber of days in a year First 5 yearsYear 6 onwards$300,000$350,000$150,000…

Needs help with similar assignment?

We are available 24x7 to deliver the best services and assignment ready within 3-4 hours? Order a custom-written, plagiarism-free paper

Order Over WhatsApp Place an Order Online

Do you have an upcoming essay or assignment due?

All of our assignments are originally produced, unique, and free of plagiarism.

If yes Order Similar Paper