equations and percentages cases
equations and percentages casesResources: Equations and Percentage Cases Excel® Template, Excel® 2016 Essential Training
Save the Equations and Percentage Cases Excel® Template to your computer.
Read the instructions on the first tab.
Complete the two Excel® cases located in the template.
Refer to the Chapter 6 Case Study 6-3 on Page 224 of your text.
Answer the following questions.
Part 1 Part 3
Room Dimensions Area in Square Feet Cost to Carpet % of total cost by Room
Master bedroom 16ft by 18 ft
Bedroom #1 12 ft by 13 ft
Bedroom #2 10 ft by 12 ft
Hallway 10 ft by 3 ft
Living room 15 ft by 20 ft
Cost to carpet per square yard
1 square yard square feet
Cost to carpet per square feet
Total Savings =Discount(%)*Total Cost
Cash they can pay
Area of carpet they can afford to buy square feet
Amount to borrow
Current Cash they hold
Amount to borrow =Total Cost – Total Savings – Current Cash they hold
Cost to carpet only bedrooms
Amount to carpet living room and hallway
Amount saved per month
No. of months months