Discount amounts in cells

Assignment Help Financial Accounting

Reference no: EM13919014

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%

Reference no: EM13919014

Questions Cloud

Identify the typical processes in manufacturing firms : In discussing characteristics of efficient plants, Goodson, developer of rapid plant assessments, suggests that numerous forklifts are a sign of poor space utilization. What do you think is behind this observation?

Personal exemption amount : Roy and Brandi are engaged and plan to get married. Roy is a full-time student and earns $9,000 from a part-time job. With this income, student loans, savings, and nontaxable scholarships, he is self-supporting. For the year, Brandi is employed and r..

Find the shortest-route distance from chicago to node six : Assume that the following network (not drawn to scale) with distances given in miles represents the highway network for this problem. Find the shortest-route distance from Chicago to node 6.

Correct cash balance as of the end of the month : What is the correct cash balance as of the end of the month? Verify this amount by reconciling the bank statement with the cash balance on the books.

Discount amounts in cells : 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 c..

Developing an ethical culture : Discuss how Kellogg, being ethical and socially minded go hand in hand. Explain how Kellogg benefits from being socially responsible, either financially or in some other way.

Explain why adjusting entries are made at the end : Victory Associates experienced the following accounting events during its 2013 accounting period.

Determine the proportions of investments a and b : Determine the proportions of investments A and B and the amount of savings and borrowing in each period that will maximize the cash value for the firm at the end of the four periods.

Methods in behavioral research : As a team, locate at least two surveys (you can use any survey that you find on the internet). Try to find one that is relatively brief- 10 questions or less. Analyze the questions in the survey. Construct a table, such as that presented on page 1..

User Account

All Pages