Hi - I have an excel with information to calculate the below question.

Please help, thank you!!

Finally, complete the following assignment.

Ryan Falkirk (responsible for the analysis on relocating the accounting functions) became ill and asked you to complete his analysis. He has identified relevant costs and benefits. However, you need to complete Steps 4, 5 and 6 of the Decision Making model. Falkirk asks that you finish his spreadsheet above. Provide your answers in the second tab of the spreadsheet, making sure to include calculations and explanations where appropriate.

Requirement 1: Ryan Falkirk identified relevant costs but didn't complete the analysis.

Complete the analysis and determine total savings (if any) each year and for the three-year period.

Make sure to use formulas and calculations in the cells to arrive at your answer.

Keep Current Locations Move to New Jersey

Annual Cost (Savings):

Block needed for relocated staff

Cost to move employees

Cost to rewire block (floor)

Annual Cost

Annual Cost over Three Year Period

Severance for Employees

Federal tax preparation

State tax preparation

SEC reporting

U.S GAAP reporting

Regulatory financial reporting

Cost accounting

General accounting

Accounts payable

Bank reconciliations

Total Cost of Severance

Total Cost over Three Year Period