BIS 155 Course Great Wisdom / tutorialrank.com BIS 155 Course Great Wisdom / tutorialrank.com | Page 12

Complete the Profit and Loss Statement provided by adding formulas
(referenced shaded cell locations) and using the product and Total
Sales data already included in Quest 1 & 2. Note: Do not just re-key
the data, but use references from the original data.
Format the Total Revenue, Expenses, and Net Income in bold, and
choose a fill color for the Net Income.
Perform a one-way analysis (i.e., Week5, iLab 6) to see at what sales
volume level MP3 player sales add at least $1,000 to net income.
Apply conditional formatting to the options that produce at least
$1,000 in net income in the above table.
Format all the numeric data and labels on the worksheet using
consistent and business like formatting options.
Save your work (CTRL+s).
Continue using the ‘Quest 4 – Financials’ worksheet:
Music on Demand (MoD) wants to apply for a 20-year loan and they
need to know how much the monthly payment will be with a
$10,000 down payment or a $20,000 down payment on a loan of
$160,000. The annual interest rate is 3% and payment is assumed to
be made at the end of the period.
Complete the chart and calculate the monthly payment, using an
Excel function.
Secure/Protect, without a password, the Quest 4-Financials
worksheet tab.
Save your work (CTRL+s).