Please Help me solve this with excel sheets. Thank you!

Yolanda Robertson, your manager at NuTrends Marketing Research, is continuing to work on the marketing information package for prospective new franchise owners. She has sent you a workbook named PBMStartup.xlsx. It contains information on the estimated capital investment required to start a new franchise, along with estimated sales and profits for the first year. The workbook calculates the number of months in which a new franchisee can expect to recoup the initial investment based on estimated sales and profits for the first year. Yolanda has asked you to use the What-If Analysis tools to find out the value required for projected sales in year 1 to pay back the initial investment in 12 months (instead of 17). Accept the proposed solution and then save the revised workbook with the name 5PBMStartup. Preview the worksheet. Part 2 After reviewing the workbook from Part 1, Yolanda is concerned that the revised sales figure is not attainable in the first year. Before you begin modifying the file, you decide to keep a copy of the original file intact. Save the workbook with the name 5-PBMStartup-2. Restore the sales for year 1 to the original value of $785,000. Yolanda has created the three models for the startup investment worksheet shown in Table 5.2. She has asked you to set up the worksheet to save all three models. Hint: Use a comma to separate the two cell references as the changing cells. Create a report that shows the input variables for each model and how the model affects the number of months needed to recoup the initial investment. Preview the scenario summary report. Switch to the worksheet and show the model that reduces the number of months to recoup the initial investment to the lowest value. Preview the worksheet. Save 5-PBMStartup-2.xlsx. Yolanda has asked you to check the accuracy of all the formulas in the worksheet before she submits it to the client. Since you did not create this worksheet, you decide to check if Excel has a feature that navigates to formula cells automatically so you do not miss any calculated cells. Use the Help feature to find out how to find and select cells that contain formulas. Based on the information you learned in Help, select the cells that contain formulas and then review each formula cell in the Formula bar to ensure the formula is logically correct. Hint: When the formula cells are selected as a group, press the Enter key to move to the next formula cell without losing the selection. When you are finished reviewing the formula cells, type the name of the feature you used in a blank cell below the worksheet and then preview the worksheet. Save the revised workbook with the name 5-PBMStartup-3. Part 4 When meeting with prospective franchise owners, Yolanda expects that individuals who do not have excellent credit ratings will find it difficult to raise the money required for the initial capital investment. Assume that the owners of Pizza by Mario are willing to finance the initial investment. Search the internet for the current lending rate for a secured credit line at the bank at which you have an account. In a new worksheet within the workbook, document the current loan rate you found and the URL of the bank website from which you obtained the rate. Add two percentage points to the lending rate to compensate the owners for the higher risk associated with financing the startup. Rename the new worksheet Loan. Create a linked cell in the Loan worksheet to the Total Estimated Initial Investment in the Startup worksheet. Calculate the monthly loan payment for a term of five years. Add appropriate labels to describe the data and format the worksheet as desired to improve its appearance. Save the revised workbook with the name 5-PBMStartup-4. Preview the Loan worksheet. Pizza by Mario Franchise Yolanda Robertson, your manager at NuTrends Marketing Research, is continuing to work on the marketing information package for prospective new franchise owners. She has sent you a workbook named PBMStartup.xlsx. It contains information on the estimated capital investment required to start a new franchise, along with estimated sales and profits for the first year. The workbook calculates the number of months in which a new franchisee can expect to recoup the initial investment based on estimated sales and profits for the first year. Yolanda has asked you to use the What-If Analysis tools to find out the value required for projected sales in year 1 to pay back the initial investment in 12 months (instead of 17). Accept the proposed solution and then save the revised workbook with the name 5PBMStartup. Preview the worksheet. Part 2 After reviewing the workbook from Part 1, Yolanda is concerned that the revised sales figure is not attainable in the first year. Before you begin modifying the file, you decide to keep a copy of the original file intact. Save the workbook with the name 5-PBMStartup-2. Restore the sales for year 1 to the original value of $785,000. Yolanda has created the three models for the startup investment worksheet shown in Table 5.2. She has asked you to set up the worksheet to save all three models. Hint: Use a comma to separate the two cell references as the changing cells. Create a report that shows the input variables for each model and how the model affects the number of months needed to recoup the initial investment. Preview the scenario summary report. Switch to the worksheet and show the model that reduces the number of months to recoup the initial investment to the lowest value. Preview the worksheet. Save 5-PBMStartup-2.xlsx. Yolanda has asked you to check the accuracy of all the formulas in the worksheet before she submits it to the client. Since you did not create this worksheet, you decide to check if Excel has a feature that navigates to formula cells automatically so you do not miss any calculated cells. Use the Help feature to find out how to find and select cells that contain formulas. Based on the information you learned in Help, select the cells that contain formulas and then review each formula cell in the Formula bar to ensure the formula is logically correct. Hint: When the formula cells are selected as a group, press the Enter key to move to the next formula cell without losing the selection. When you are finished reviewing the formula cells, type the name of the feature you used in a blank cell below the worksheet and then preview the worksheet. Save the revised workbook with the name 5-PBMStartup-3. Part 4 When meeting with prospective franchise owners, Yolanda expects that individuals who do not have excellent credit ratings will find it difficult to raise the money required for the initial capital investment. Assume that the owners of Pizza by Mario are willing to finance the initial investment. Search the internet for the current lending rate for a secured credit line at the bank at which you have an account. In a new worksheet within the workbook, document the current loan rate you found and the URL of the bank website from which you obtained the rate. Add two percentage points to the lending rate to compensate the owners for the higher risk associated with financing the startup. Rename the new worksheet Loan. Create a linked cell in the Loan worksheet to the Total Estimated Initial Investment in the Startup worksheet. Calculate the monthly loan payment for a term of five years. Add appropriate labels to describe the data and format the worksheet as desired to improve its appearance. Save the revised workbook with the name 5-PBMStartup-4. Preview the Loan worksheet. Pizza by Mario Franchise