this is important homework and I expect full mark. please read the instruction carefully.This means a Word document, Excel spread sheet or hand written you will be deducted for using any Excel macros involving present worth, annual worth, err, irr, etc.You can use macros like a random number generator, solver, normal table, etc.To simplify grading please highlight your answer in the Excel sheet (Different color and bigger font) You own an old wave runner (small boat for one or two people).If the wave runner is in working order, then you can sell it for $2,000 with very little effort.Last month the steering chassis broke and it cost $1,000 to fix.Last weekend you were out on a lake and had to paddle the wave runner back to shore.You blew the motor and it will cost $1,500 to replace the motor.Should you get the wave runner fixed and why? Using formulas and the tables in the book, determine the present worth, annual worth and future worth of the following investment strategy.Invest $1,500 dollars today and invest $50 for every month for the next 5 years.Assume that the annual nominal interest is 6%, which is compounded monthly. Please write down all relative formulas.Use the table values, do not use Excel.However, put the answer in an Excel sheet.Only use the table values uploaded to the course. (i.e.Present worth = 300*(P/A,.02,4) + 1000 (P/F,.02,4) +10000) You get a starting job offer with a company.The salary is $60,000. The company offers one of two options.A fixed $2,000 raise each year or a 2.5% raise a year.How many years do you have to stay with the company to make the 2.5% increase better than the consistent $2,000 raise.You consider your interest rate to be inflation at 2%.A. Done in excel.In January 2018, I refinanced my home for $279,000 in a 5 year arm at 3.125.Surprisingly, I was able to convince the bank to give me a 25 year loan. Currently, I owe $235,000.I am debating about refinancing.The fees and everything will cost me $5,000.I can refinance to a 15 year loan at 2.5%.How long do I have to stay in this house to make the refinance financially beneficial assuming that the ARM stays at 3.125% for the life of the loan? Consider the following problem.A company (that is highly successful and annual profit is between 3 million and 5 million) is considering purchasing two machines.Below are the costs regarding these two machines. MachineABCost of Machine$90,000$130,000Shipping/installation costs$10,000$10,000Annual Receipts$60,000$90,000Annual Disbursement$20,000$35,000Life of the machine3 years4 yearsSalvage Value at endof life$0$10,000MARR 10%What are the present worths of both machines using formulas and tables.Do not combine cash flows? What is the best choice based upon PW using Excel? What is the best choice based upon FW in Excel? What is the best choice based upon AW in Excel? Comment on any additional criteria that may influence your decision? 5 b. Answer the above question, if you assume that inflation is 2% per year.This means a Word document, Excel spread sheet or hand written you will be deducted

for using any Excel macros involving present worth, annual worth, err, irr, etc. You can

use macros like a random number generator, solver, normal table, etc. To simplify

grading please highlight your answer in the Excel sheet (Different color and bigger font)

1. You own an old wave runner (small boat for one or two people). If the wave

runner is in working order, then you can sell it for $2,000 with very little effort.

Last month the steering chassis broke and it cost $1,000 to fix. Last weekend you

were out on a lake and had to paddle the wave runner back to shore. You blew

the motor and it will cost $1,500 to replace the motor. Should you get the wave

runner fixed and why?

2. Using formulas and the tables in the book, determine the present worth, annual

worth and future worth of the following investment strategy. Invest $1,500

dollars today and invest $50 for every month for the next 5 years. Assume that

the annual nominal interest is 6%, which is compounded monthly. Please write

down all relative formulas. Use the table values, do not use Excel. However, put

the answer in an Excel sheet. Only use the table values uploaded to the course.

(i.e. Present worth = 300*(P/A,.02,4) + 1000 (P/F,.02,4) +10000)

3.

You get a starting job offer with a company. The salary is $60,000. The

company offers one of two options. A fixed $2,000 raise each year or a 2.5%

raise a year. How many years do you have to stay with the company to make the

2.5% increase better than the consistent $2,000 raise. You consider your interest

rate to be inflation at 2%.

4. Consider the following problem. A company (that is highly successful and annual

profit is between 3 million and 5 million) is considering purchasing two

machines. Below are the costs regarding these two machines.

Machine

Cost of Machine

Shipping/installation costs

Annual Receipts

Annual Disbursement

Life of the machine

Salvage Value at end

of life

MARR 10%

A

$90,000

$10,000

$60,000

$20,000

3 years

B

$130,000

$10,000

$90,000

$35,000

4 years

$0

$10,000

a. What are the present worths of both machines using formulas and tables. Do not

combine cash flows?

b. What is the best choice based upon PW using Excel?

c. What is the best choice based upon FW in Excel?

d. What is the best choice based upon AW in Excel?

e. Comment on any additional criteria that may influence your decision?

f.

5. A. Done in excel. In January 2018, I refinanced my home for $279,000 in a 5

year arm at 3.125. Surprisingly, I was able to convince the bank to give me a 25

year loan. Currently, I owe $235,000. I am debating about refinancing. The fees

and everything will cost me $5,000. I can refinance to a 15 year loan at 2.5%.

How long do I have to stay in this house to make the refinance financially

beneficial assuming that the ARM stays at 3.125% for the life of the loan?

5 b. Answer the above question, if you assume that inflation is 2% per year.

Purchase answer to see full

attachment

#### Why Choose Us

- 100% non-plagiarized Papers
- 24/7 /365 Service Available
- Affordable Prices
- Any Paper, Urgency, and Subject
- Will complete your papers in 6 hours
- On-time Delivery
- Money-back and Privacy guarantees
- Unlimited Amendments upon request
- Satisfaction guarantee

#### How it Works

- Click on the “Place Order” tab at the top menu or “Order Now” icon at the bottom and a new page will appear with an order form to be filled.
- Fill in your paper’s requirements in the "
**PAPER DETAILS**" section. - Fill in your paper’s academic level, deadline, and the required number of pages from the drop-down menus.
- Click “
**CREATE ACCOUNT & SIGN IN**” to enter your registration details and get an account with us for record-keeping and then, click on “PROCEED TO CHECKOUT” at the bottom of the page. - From there, the payment sections will show, follow the guided payment process and your order will be available for our writing team to work on it.