Cash Flow Analysis, business and finance assignment help

Analyze the “Frank Smith Plumbing’s Financial Statement” spreadsheet. “Attached Below” and Compare the cost of the truck to the cash flow records plus Compile your calculations in a Microsoft® Excel® document and show and explain within Excel spreadsheet how those solutions are obtained for each financial calculation showing “Excel Notations” and making good detailed Recommendations highlighted in yellow based on “Frank Smith Plumbing’s Financial Statement” spreadsheet that is “Attached Below”

Appreciate any help and good detailed explanation I can receive from in obtaining those calculations, especially in knowing how to obtain answers for the discounted cash flow needed for DPB Calculation listed under “Decision Criteria” on the spreadsheet. Attached as well is the “Frank Smith Case Study” that goes with the Financial Statement spreadsheet. Thanks!