The Discount amounts in cells D4, D5, D6 and D7 are computed using the IF function. The discount amount in column D should equal the Discount % from the assumptions area multiplied by the Sales figure from the column B if the corresponding Sales in column B is greater than or equal to $300,000. If the corresponding Sales in column B is less than $300,000, then the Discount amount is calculated us 5% as the discount percentage. The IF function in cell D4, D5, D6, and D7 are incorrect. Edit and correct the IF function and show formulas.
|
|
|
|
|
|
|
|
WheelsAboutTown.com Annual Projected Net Income
|
|
Contract
|
Sales
|
Transportation Costs
|
Discounts
|
Maint. Costs
|
Net Income
|
|
Media Outlets
|
$350,124.50
|
$32,211.45
|
$42,014.94
|
$29,760.58
|
$246,137.52
|
|
Publishers
|
267,543.95
|
$24,614.04
|
13,377.20
|
#REF!
|
#REF!
|
|
Financial Consortium
|
642,245.50
|
$59,086.59
|
77,069.46
|
-
|
506,089.45
|
|
Downtown Hotel Core
|
456,955.25
|
$42,039.88
|
54,834.63
|
#VALUE!
|
#VALUE!
|
|
Total
|
$1,716,869.20
|
$157,951.97
|
$187,296.23
|
#REF!
|
#REF!
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Assumptions
|
|
|
|
|
|
|
Transportation %
|
9.20%
|
|
|
|
|
|
Discount %
|
12.00%
|
|
|
|
|
|
Maint. Costs %
|
8.50%
|
|
|
|
|