Posted: November 2nd, 2022

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?

Place your order now for a similar assignment and have exceptional work written by our team of experts, At affordable rates

For This or a Similar Paper Click To Order 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.

For This or a Similar Paper Click To Order Now