Help in solving present worth. Show work and functions to use in excel.

Item Cost per Unit Annual Total Direct Material 2.00 $20,000 Direct Labor 6.00 $60.000 Indirect Labor 2.50 $25,000 Indirect Overhead cost 0.50 $5,000 Total manufacturing costs 5.50 $55,000 General and development cost 1.34 $13,400 Total revenues 6.00 $60,000 Profit (loss) -2.24 -$22,400 Present Worth? General and development cost = 20% of cost of goods n = 4 years Item Cost per Unit Annual Total Direct Material 2.00 $20,000 Direct Labor 6.00 $60.000 Indirect Labor 2.50 $25,000 Indirect Overhead cost 0.50 $5,000 Total manufacturing costs 5.50 $55,000 General and development cost 1.34 $13,400 Total revenues 6.00 $60,000 Profit (loss) -2.24 -$22,400 Present Worth? General and development cost = 20% of cost of goods n = 4 years