Hello can you please walk me through how to do this the annual income is 113,300 It is wise to set aside 7.5% of gross monthly income for 401 k investment. Assume the investment earns a 5% annual return and use Excel to determine the balance after 40 years for the unskilled worker and for your expected income. Then use Excel to determine how many years it would take for the unskilled worker and for your expected investment to reach $500,000.

Answer using excel: Machine A costs $316 and produces a profit of $106 at the end of each year for 7 years, while Machine B costs $128 and produces a profit of $71 at the end of each year for 4 years. Assuming the operation continues indefinitely and the cost of capital is 13%. Calculate equivalent annual value (EAV) to determine the better option. Enter EAV for Machine A below.

You volunteer on a local fire department and are asked to help in the purchase of a new fire engine. You seek out a loan from a bank in which they state the annual interest on the loan would be 10%. However, the interest compounds once per quarter. What is the effective annual percentage rate (APR) if you select this loan?     10.38%     10%     15.1%     1.11%

can u help me

Your new job offers a savings plan that pays 0.75 percent in interest each month. You can't participate in the plan, however, until you have 5 years with the company.  At that time you will start saving $100 a month for the next 28 years.     How much will you have in this savings account in 33 years? Round your answer to two decimals.     $     Another perk of your new job is that, after 5 years with the company, you will also get an increase of $125 in your monthly salary. Assume you would stay with the company for 28 more years after getting the salary increase, and that you discount at 0.75 percent each month.     What is this salary increase worth to you today? Round your answer to two decimals.

Please please solve in excel Only Only excel and show step

Present value. You are currently in the job market. Your dream is to earn a six-figure salary ($150,000). You hope to accomplish this goal within the next 28 years. In your field, salaries grow at 3% per year. What starting salary do you need to reach this goal? What starting salary do you need to reach this goal? (Round to the nearest cent.)

Solve it correctly please. I will rate accordingly.

You have been offered a contract to work as a consultant. The company will pay you $6215 per month.  In addition, once you complete the work in 4 years, you will receive $46865. Your required return is 6.57%, what is this contract worth today? show all step and fomular. Answer