Peregrine_Excel.xlsx

Sheet1

Option 1: Purchase the CNC Machine with Cash
Year 0 Year 1 Year 2 Year 3 Year 4 Year 5
Inflows Gross Revenue
Salvage value
Total Inflows
Outflows
Initial purchase
Cost of Goods Sold
Operating Costs
Total Outflows
Overall Cashflow
Option 2: Finance the Purchase of the CNC Machine
Year 0 Year 1 Year 2 Year 3 Year 4 Year 5
Inflows Gross Revenue
Salvage value
Total Inflows
Outflows
Initial purchase
Cost of Goods Sold
Operating Costs
Lease payments
$1 payment
Total Outflows
Overall Cashflow
Option 3: Add a Third Shift
Year 0 Year 1 Year 2 Year 3 Year 4 Year 5
Inflows Gross Revenue
Outflows
Cost of Goods Sold
Operating Costs
Total Cash Outflows
Overall Cashflow
Our customer support team is here to answer your questions. Ask us anything!