In Cell H4, enter a formula to calculate the projected secondquarter. Enter a formula to multiply the
Fantastic news! We've Found the answer you've been seeking!
Question:
In Cell H4, enter a formula to calculate the projected secondquarter. Enter a formula to multiply the first quarter value by 1plus the projected increase.
| $0 | April | May | June | (1Q) Total | Avg | 1Q | (H4) Increase Decrease | |
| North | $500,000 | $150,000 | $325,000 | $975,000 | $825,000 | $ | 0.15 | |
| South | $125,000 | $250,000 | $50,000 | $425,000 | $450,000 | |||
| Central | $300,000 | $250,000 | $175,000 | $725,000 | $800,000 | |||
| Total | $925,000 | |||||||
| Avg | $308,333 |
| $0 | April | May | June | Total | Avg | 1Q | Projected Increase Decrease | Actual Increase Decrease |
| North | $500,000 | $150,000 | $325,000 | $975,000 | $325,000 | $825,000 | $845,625 | 0.15 |
| South | $125,000 | $250,000 | $50,000 | $425,000 | ||||
| Central | $300,000 | $250,000 | $175,000 | $725,000 | ||||
| Total | $925,000 | |||||||
| Avg | $308,333 |
Expert Answer:
Related Book For 
Financial Algebra advanced algebra with financial applications
ISBN: 978-0538449670
1st edition
Authors: Robert K. Gerver
Posted Date:
