4.Add formulas to complete the table of hours used. In cell B17, create a nested formula with the IF and SUM functions that check if the total number of hours worked in week 1 (cells B9:F9) is equal to 0. If it is, the cell should display nothing (indicated with two quote marks: ""). Otherwise, the cell should display the total number of hours worked in week 1. Copy the formula from cell B17 to fill the range B18:B20.

You are thinking of making your mansion more energy efficient by replacing some of the light bulbs with compact fluorescent bulbs, and insulating part or all of your exterior walls. each compact fluorescent light bulb costs $4 and saves you an average of $2 per year in energy costs, and each square foot of wall insulation costs $1 and saves you an average of $0.20 per year in energy costs.† your mansion has 150 light fittings and 3000 sq ft of uninsulated exterior wall. to impress your friends, you would like to spend as much as possible, but save no more than $750 per year in energy costs (you are proud of your large utility bills). how many compact fluorescent light bulbs and how many square feet of insulation should you purchase? how much will you save in energy costs per year? (if an answer does not exist, enter dne.)

Match the different financial task to their corresponding financial life cycle phases

You are in the market for a new refrigerator for your company’s lounge, and you have narrowed the search down to two models. the energy efficient model sells for $700 and will save you $45 at the end of each of the next five years in electricity costs. the standard model has features similar to the energy efficient model but provides no future saving in electricity costs. it is priced at only $500. assuming your opportunity cost of funds is 6 percent, which refrigerator should you purchase