Unit 11 of 12 Lesson 1 free · Plus

Business math

Growth, margins, loans, and savings.

Key ideas

=(C2-B2)/B2

New minus old, divided by old. Format it as a percent.

=PMT(rate/12,years*12,amount)

Use monthly rate and number of months. The result is negative because money goes out.

=SUMPRODUCT(B2:B5,C2:C5)/SUM(C2:C5)

Multiply each score by its weight, add them up, divide by total weight.

Find the growth from last year to this year as a decimal in D2. Fill to D5.
A B C D
1 Product Last year This year Growth
2 Notebook 4000 4600
3 Pen 2500 2250
4 Stapler 1200 1500
5 Binder 800 880
Hint: =(C2-B2)/B2
Show answer
=(C2-B2)/B2 in D2. 0.15 means 15% growth. The Pen shrank by 10%.
What will A1 show?
A
1
A1 contains =(120-100)/100
Show answer
0.2. 20 more on a base of 100 is 0.2, or 20%.
The discount in F1 applies to every price. Write the sale price in C2 so it fills to C5.
A B C D E F
1 Product Price Sale price Discount 0.15
2 Lamp 40
3 Desk 220
4 Chair 150
5 Rug 90
Hint: Pay 85% of the price: =B2*(1-$F$1)
Show answer
=B2*(1-$F$1) in C2. Lock the discount cell so every row shares it.
Price is $50 and cost is $30. What is the profit margin?
- 40%
- 66.7%
- 20%
- 60%
Show answer
40%. Margin is profit divided by price: 20 / 50.
Calculate the profit margin (profit divided by price) in D2. Fill to D4.
A B C D
1 Item Price Cost Margin
2 Mug 18 7.2
3 Tote 25 11
4 Cap 22 13.2
Hint: =(B2-C2)/B2
Show answer
=(B2-C2)/B2 in D2. Margin is on price. Markup would be on cost.

	A
1

Lesson 2 is part of Cellwise Plus. Lesson 1 above is free to read here and to practice in the app.

Lesson 3 is part of Cellwise Plus. Lesson 1 above is free to read here and to practice in the app.