Select Page

GET HELP WITH YOUR ESSAY

If you need assistance with writing your essay, our professional Essay Writing Service is here to help!

DISCOUNT CODE FIRST25

ORDER THIS OR A SIMILAR PAPER NOW

Finish the attached document.
There are 3 Worksheet Tabs in this Excel file; First Q, First Q Goal Seek, and Minivan Loan.
The First Q (First Quarter) tab shows the first quarter revenue and expenses of the Downtown Internet Cafe. For this tab,
Complete the Proportion column, cells G7 through G11. Each proportion value shows the % of the quarterly sale of that item over the entire sale. (10 points)
Calculate the Net Income row, cells B24 through F24. (10 points)
Compute the Profit Margin row, Cells B25 through E25. (10 points)
Add Net Income Sparkline for January through March in Cell H24. (5 points)
The First Q Goal Seek tab is a copy of the First Q sheet that you apply the Goal Seek Analysis. For this tab,
Apply the Goal Seek Analysis to increase the Profit Margins of Jan. through Mar. up to 30% by changing the Payroll each month. (20 points)
Add new Net Income Sparkline for January through March in Cell H24. (5 points)
Compare the two Net Income Sparklines and in one sentence explain the difference. (5 points)
The Minivan Loan tab shows the information that is needed to buy a Minivan for the Downtown Internet Cafe. For this tab,
Review the instructions on the top of the worksheet carefully.
Calculate the Monthly Payment for the car loan based on the given information. (15 points)
If the Downtown Internet Cafe wants to pay off the car loan faster, by paying every other week, how much do they have to pay bi-weekly? (15 points)
Add your full name on the lower left side of the spreadsheet as shown. (5 points)
You should have ONE Excel file with 3 worksheet tabs. So, do not make any other formatting changes to this file.
Make sure to have all formulas where needed. Missing any single formula will cost you points. Using numbers instead of cell references in your formulas will cost you points.

DISCOUNT CODE FIRST25

ORDER THIS OR A SIMILAR PAPER NOW