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