This is just a homework assignment I am needing the answers to
Question 1
Find the correct excel formula to find the total in a savings account:
Monthly Amount = $1800
Interest Rate = 0.15%
Years in Account = 25
Group of answer choices
=FV(0.0015/12,25*12,-1800)
=FV(0.15/12,25*12,-1800)
=FV(0.0015,300,-1800)
=FV(0.15/12,300,-1800)
=FV(.0015/12,25*12,1800)
Question 2
An employer will do a 50% match on your investment to a 401k retirement plan. If you decide to contribute a monthly amount of $220, how much should be in the account after 15 years? The interest rate is fixed at 2.05%.
Question 3
Find the total in the account with the following facts:
Monthly contributions = $180
Employer matching = 25%
Interest rate = 4.99%
Years invested = 38
Question 4
John makes $2,800 per month and has an opportunity to invest $150 per month at an APR of 4.5% in a 401K plan through work. He plans to retire in 30 years.
Type in the EXACT formula you would use in excel (no spaces) to find the amount in the account after he has invested for 30 years.
Using excel, what is the answer to the formula from the previous part?
How much money will he deposit into the 401K over the 30 years?
How much total interest will he earn on his 401K over the 30 years?
Question 5
You have recently signed up for a new job and noticed this policy for retirement savings. Invest $200 and the employer does 70% matching for 35 years at an interest rate of 4.8%.
Find the total amount that the employer contributes each month.
What amount will you have after 35 years?
How much money have you deposited into the account yourself?
How much more money is in the account than what you have deposited?
Question 6
Consider this scenario:
In 1986, a family member invested $100 each month into a savings account with an interest rate of 0.25% (that didn’t change). In 2016, you decided you needed to use that saved up money for a big purchase, so you cash the savings account out.
How much money should be in the account using the FV formula?
If your family put the $105 each month instead of just the $100, how much extra would be in the account compared to the total value from the first part?
If you were to invest $200 each month, what would your savings account have in 2016?
Question 7
How much interest did you gain if you invested in a retirement plan with a rate of 2.5% over 42 years? Your monthly deposits totaled $520.
Papers are written from scratch We have molded our writers to develop content for all assignments from scratch. This way, we promote originality and reduce cases of plagiarism that might affect your grades and hinder you from realizing your academic goals. We encourage our clients to indicate the deliverables that should be featured in the final paper. Our online help services allow one to make a clarification and even interact with the writer directly to help them understand the needs of the assignment. Many of our writers are professional tutors who understand the approaches that should be used to fulfill the specified instructions. Every time a client places an order on our system, we link them with the most qualified writer in the subject of interest.
YUnlike other writing companies, we encourage clients to draw back their money at any stage of the writing process if they experience any uncertainties with the quality of generated content. However, you will hardly have to make this decision because of our business approach that suits your needs.
We have an advanced plagiarism-detection system that flags any work that fails to meet the required academic expectations. Our company thrives in honesty, and as such, you will be guaranteed to achieve a paper that meets your expectations.
We encourage our clients to return papers for revision seven days after the last submission for free. Depending on the proposed changes, we will work on your article to achieve the desired expectations.
We uphold confidentiality and privacy through our interactions with clients, an aspect that has enhanced our relationship with prospective customers seeking for assignment help. We do not disclose your information with third-parties
We boast of a diverse pool of ENL and ESL professionals who respond with a personal touch to the needs of every client. Our focus is to become the best platform that offers specialized services to individuals to accomplish their academic goals.
