Advanced Spreadsheet Assignment Help

Mount Moreland Hospital
PERFORM FINANCIAL CALCULATIONS
GETTING STARTED
• Open the file NP_EX19_9a_FirstLastName_1.xlsx, available for download from the SAM website.
• Save the file as NP_EX19_9a_FirstLastName_2.xlsx by changing the “1” to a “2”.
o If you do not see the .xlsx file extension in the Save As dialog box, do not type it. The program will add the file extension for you automatically.
• With the file NP_EX19_9a_FirstLastName_2.xlsx still open, ensure that your first and last name is displayed in cell B6 of the Documentation sheet.
o If cell B6 does not display your name, delete the file and download a new copy from the SAM website.
PROJECT STEPS
1. Pranjali Kashyap is a financial analyst at Mount Moreland Hospital in Baltimore, Maryland. She is using an Excel workbook to analyze the financial data for a proposed program called Neighborhood Nurse. The program involves nurses and nurse practitioners providing healthcare services to Baltimore neighborhoods from a van outfitted with medical equipment and supplies. She asks for your help in correcting errors and making financial calculations in the workbook.
Go to the Loan Payments worksheet. The hospital needs a loan to buy the medical van for the Neighborhood Nurse program. Before Pranjali can calculate the principal and interest payments on the loan, she asks you to correct the errors in the worksheet. Correct the first error as follows:
a. In cell H17, use the Error Checking command to identify the error in the cell.
b. Correct the error to total the values in the range C17:G17. In a later step, you will calculate the interest and principal in the range C17:G18 to remove the remaining errors.
2. Correct the