All yelow cells must be a formala or cell reference in order to get fall credi. Cost of equipment Required working capiral Charge per wse for washers Charge per use for dryers Expected weeikly gross for washers Expected weekly gross for dryers Variable cost per use for washers Variable cost per use fo Fixed costs PER MONTH 194,000 washers, dryers, and other equipmen 56,000 sap, ec. Will be released at end of Yr 6 51.50 pe 0.5 per USE 51,800 per WE 1,125 per WEEK per USE erUSE for water and electricity USE for gas and electric 009 per Building rent $1,500 per MONTH $1,875 per Maintenance, insurance, oher Sahage valbe of equipment in 6 Required rate of retunn Weeks per year the laundromat is open 52 (1) Assuming the la undromat would be open 52 weeks a year, compute the expecte aal net cash receipts from its operations(gross cash receis less cash Average WEEKLY us of washers and Washers Per Use Per Use Expected net amal cash receips Washer cash receipts Dryer cash receips Toal cash receips Less cash disbursements Washer: water & electric Dryer: gas &electric Rent Maitenance and other Toal cash disursements Amalnetcash receip 2) Compute the NPV for this investment. Rememiber, cash inflows are shomm as positive ambers. I did the formalis in Cola mmbers and cash outfbas are shoan as for you but you should go and look at them. (The ROUNDO Funetion will round an answer the umiber of decimal places specified after the comma. In this case it isz 12% Cash Fors Factor PV ofCash Item Ye Working capital Amalnetcash receip Savage vale of equipment Working capital released 50 50 50 50 1.000 -6 0507 0507 Net Present Vale