Based on trucking venture specificsTotal investment Cost of the truck $95,000Working capital. $ 5,000Operations per year four Trucking Revenue $200,000Less Driver's salary. $ 95,000Insurance. $. 20,000Fuel and Mant. $ 50,000Total expenses. $165,000Net anual cash flows. $ 35,000Disinvestment Sale of the truck. $25,000Recovery of working ca $2,00"Total disinvestment. $27,000Please answer the questions below

Scenario You are a staff accountant for Totally Chemical, a small organization that specializes in swimming pool chemicals. The vice president of operations indicate organization is looking to expand into the trucking business so that Totally Chemical can increase its client base. The vice president has asked you to perf project and then email your findings. The skills practiced in this activity will help to support you in your project. Directions Use the knowledge you gained from this module's resources to consider capital budgeting methods and how investment decisions can impact an organiz activity. Specifically, you must address the following rubric criteria: Part One: Excel Calculations For Part One, use the template in the What to Submit section to show your work in calculating the methods of capital budgeting. 1. Calculate the net present value (NPV) method of capital budgeting. 2. Calculate the internal rate of return (IRR) method of capital budgeting. 3. Calculate the payback period (PP) method of capital budgeting. Part Two: Executive Summary Email For Part Two, write an executive summary email in a separate Microsoft Word document that describes the data from the calculations you did in Part On 1. Describe the impacts of using NPV and IRR versus PP and annual recurring revenue (ARR). 2. Explain why the NPV and IRR are considered the time value of money methods. 3. Determine how capital budgeting helps the organization achieve its strategic objectives. 4. Determine whether to accept or reject the investment decision project based on the NPV. What to Submit . Excel Calculations Using the Module Six Activity Template, complete the Excel calculations in Part One of this activity. Executive Summary Email Complete the Part Two email in a separate 1-page Word document with double spacing, 12-point Times New Roman font, and one-inch margins. S APA style. Submit both for grading. Supporting Materials The following resource supports your work on this activity: Resource: Totally Chemical Organization Profile This document provides information about the organization