Cubpaw the most basic of your policies is a liability only i

Cub-paw, the most basic of your policies, is a liability only insurance policy that is available only to undergraduate students who are permanent residents of the State of Maine and also to those making less than $15,000 annually. Its base rate is ½ of the Mini-paw policy and is the most economical offering that the company can provide.

Thia is for my excel class i need to type formulas and figure out answer s i cant figur it out can someone help?

$600.00

Solution

*

The basic percentage formula is as follows:

(Part/Whole)*100 = Percentage

*

*

Excel formula for percentage change (percentage increase / decrease)

To calculate percent change between values A and B, use the following formula:

(B - A) / A = Percent Change

When applying this formula to real data, it is important that you correctly determine which value is A and which is B. For example, yesterday you had 80 apples and how you have 100, meaning that now you have 20 apples more than before, which is 25% increase. If you had 100 apples and now you have 80, your number of apples has reduced by 20, which is 20% decrease.

Considering the above, our Excel formula for percentage change takes the following shape:

(New Value - Old Value) / Old Value = Percent Change

*

To increase an amount by a percentage, use this formula:

= Amount * (1 + %)

For example, the formula =A1*(1+20%) increases the value in cell A1 by 20%.

To decrease an amount by a percentage:

= Amount * (1 - %)

For instance, the formula =A1*(1-20%) reduces the value in cell A1 by 20%.

In our example, if A2 is your current expenditures and B2 is the percentage you want to increase or reduce that amount by, here are the formulas you\'d enter in cell C2:

Increase by percentage: =A2*(1+B2)

Reduce by percentage: =A2*(1-B2)