Peregrine_Excel.xlsx

Posted on June 5, 2023 | by

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

Get Answer