Please show formula and show HOW TO CALCULATE FROM STEP BY STEP! I have to follow the structure and put into excel THANK YOU!

The Golden Digital Company has been offered a five-year contract to haul munitions for the government. Since this contract would represent new business, the company would have to purchase several new heavy-duty trucks at a cost of $350,000 if the contract were accepted.Other data relating to the contract follow:

Annual Cash Revenue $ 400,000.-

Annual Cash Expense $ 295,000.-

Cost of replacing the motors in the trucks in the fourth year $ 18,000.-

Cost of Advertising in the second year $ 3,000.-

Salvage value of the trucks at termination of the contract $ 15,000.-

To raise money to assist in the purchase of the new trucks, the company will sell several old, fully depreciated trucks for a total selling price of $16,000. The company requires a 10% return on all equipment purchases (Table 2, 10%). The tax rate is 25%.

REQUIRED

Compute the net present value of this investment opportunity. Would you recommend that the contract be accepted?

Financial Table 2 (Present Value)

ILI Part I: Cash Budget Beginning Cash Estimated cash receim Sales Other Income Total Estimated Cash Receipt Estimated cash disbursement Cash Purchase Other Cash Expense Purchase Furniture Cash dividends Mam Interest Rent Depreciation Taxes Total Estimated Cash Disbursement Ending Cash Balance El