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 ).