Question

I need this put in an excel spreadsheet

Cost $ oeddraft.jpg Open with - The Cutting Edge-Landscaping The Cutting Edge-Landscaping Capital Expenditures Budget Usefu Lite tem Description Salvage ONY Total Cost Depr Base Value Depr Exp in Yrs Desk 1 $600 $600 $240 $360 7 $51 Computer 1 $750 $750 $300 5 $90 Copier/printer/fax machine 1 $100 $100 $40 $60 5 $12 Customer Chairs 6 $30 $180 $72 $108 5 $22 Office Chair 1 $100 $100 $40 $60 5 $12 sao о Truck 2 $25,000 $ $50 000 $20,000 6 6 $5.000 Trailer 2 $1,899 $3.798 $1,519 7 $326 1.00 Large Riding Lawnmower 2 $2,599 $5 198 $2.079 $3.119 5 $624 Small Riding Lawnmower 2 $1,499 $2 998 $1,199 $1,799 $ 5 $360 Push Lawnmower 2 $239 5478 $191 S287 5 $57 Gas Trimmer 2 $94 $188 $75 $113 5 $23 2 $200 Gas Edger $400 $ $160 5 $240 $48 2 $129 Gas Blower $258 5103 $155 5 $31 2 $400 $200 $240 5160 Gas Hedge Trimmer 5 $48 2 $160 Gas Tree Trimmer $128 $320 5 $192 2 $120 $240 $96 $144 5 $29 Long Ladders 566,008 S26,403 S39,605 Total 56,770 $450 + 235 PM 220/2020 CE hp

Answer 1

Answer

As required data is created in Excel & Copied and pasted.

	The Cutting Edge - Landscaping
	Capital Expenditure Budget
	Item Description	Qty	Cost	Total Cost	Salvage value	Depr Base	Useful Life in Yrs	Depr exp
	Desk	1	$     600	$     600	$          240	$          360	7	$          51
	Computer	1	$     750	$     750	$          300	$          450	5	$          90
	Copier/printer/fax machine	1	$     100	$     100	$            40	$            60	5	$          12
	Customer Chair	6	$       30	$     180	$            72	$          108	5	$          22
	Office Chair	1	$     100	$     100	$            40	$            60	5	$          12
	Trusk	2	$ 25,000	$ 50,000	$      20,000	$      30,000	6	$      5,000
	Trailer	2	$   1,899	$   3,798	$       1,519	$       2,279	7	$        326
	Large Riding Lawnmower	2	$   2,599	$   5,198	$       2,079	$       3,119	5	$        624
	Small Riding Lawnmower	2	$   1,499	$   2,998	$       1,199	$       1,799	5	$        360
	Push Lawnmower	2	$     239	$     478	$          191	$          287	5	$          57
	Gas Trimmer	2	$       94	$     188	$            75	$          113	5	$          23
	Gas Edger	2	$     200	$     400	$          160	$          240	5	$          48
	Gas Blower	2	$     129	$     258	$          103	$          155	5	$          31
	Gas HedgeTrimmer	2	$     200	$     400	$          160	$          240	5	$          48
	Gas Tree Trimmer	2	$     160	$     320	$          128	$          192	5	$          38
	Long Ladders	2	$     120	$     240	$            96	$          144	5	$          29
	Total			66008	$      26,403	$      39,605		6770