pls put anwers as cell formulas

Conch Republic Electronics, Part 2 Input Area: EquipmentSalvagevalueR&DMarketingstudy$$$$43,500,0006,500,000750,000200,000sunkcostsunkcost Lostsales95,00030,00065,00030,000 PriceVCFCPriceofoldPDA$$$$5352206,400,000385 Price reduction ofoldPDAVCofoldPDA$$215145 Tax rate 21% NWCpercentagoRequiredreturn20%12% Sensivity analysis New price $540 Quantity change 100 NOTE: Change in units per year Output Area: Sensittivity to change in price Conch Republic Electronics, Part 2 Input Area: EquipmentSalvagevalueR&DMarketingstudy$$$$43,500,0006,500,000750,000200,000sunkcostsunkcost Lostsales95,00030,00065,00030,000 PriceVCFCPriceofoldPDA$$$$5352206,400,000385 Price reduction ofoldPDAVCofoldPDA$$215145 Tax rate 21% NWCpercentagoRequiredreturn20%12% Sensivity analysis New price $540 Quantity change 100 NOTE: Change in units per year Output Area: Sensittivity to change in price