Скачать или смотреть New Perspectives Excel 365/2021 | Module 9: SAM Project 1b | ChargeAll

Hire Me For Complete Course , Assignments & Exams=================
For Help Contact Me on=========================================
WhatsApp:+923466480850
WhatsAppLink: https://wa.link/2a6jcc
Email: [email protected]

We are providing help in all Online Courses, Computer Science, Business and Management, Business Math, Business and Finance, Business and Accounting, Human Resource Management, History, English, Literature, Nursing, psychology, Statistics, Information Technology, Applied Sciences and Many more We will help you with weekly quizzes, assignments, exams, thesis writing, Dissertation writing and Technical Writing.


#Excel_Module9_SAM_Project_B #ExcelModule9SAMProjectB #NP #EX19 #NP_EX19_9b #ExcelModule9SAMProj1b #Excel_Mod_9 #ExcelMod9 #Excel_Mod9_SAM_Project_1b #NP_EX19_9b_FirstLastName_1.xlsx #ChargeAll_Project #ChargeAllExcel
#New_Perspectives_Excel_2019_Module9_SAM_Project_1b #NewPerspectivesExcel2019Module9SAMProject1b #Shelly_Cashman_Excel_2019_Module9_SAM_Project_1b #ShellyCashmanExcel2019Module9SAMProject1b #Cengage #Excel2019

#Excel_Module9_SAM_Project_B
#ExcelModule9SAMProjectB_Tutorial
#ExcelMod9SAMProjectB
#CengagePearsonPro
#Excel_Module9_SAM_Project1b
#ExcelModule9SAMProject1b_Guide
#ExcelMod9Proj1b
#CengagePearsonPro
#Excel_Module9_SAM_Project_B_ChargeAll
#ExcelModule9SAMProjectB_ChargeAll
#Excel9b_ChargeAllProject
#CengagePearsonPro
#NP_Excel2019_Module9_SAM_Project1b
#NPExcel2019Module9SAMProj1b
#NewPerspectivesExcel2019_Mod9b
#CengagePearsonPro
#ShellyCashman_Excel2019_Module9b
#ShellyCashmanExcel2019_9b
#Shelly_Cashman_Mod9_SAM_Project1b
#CengagePearsonPro
#ChargeAll_Project
#ChargeAllExcel
#ChargeAll_Module9
#CengagePearsonPro
#FinancialCalculations_Excel
#Perform_Financial_Calculations
#FinancialCalcsExcel
#CengagePearsonPro
#NP_EX19_9b_File1
#NP_EX19_9b_File2
#NP_EX19_9b
#Cengage
#NP
#EX19
#Cengage_Excel_Module9_SAM_Project_B



New Perspectives Excel 365/2021 | Module 9: SAM Project 1b

ChargeAll
PERFORM FINANCIAL CALCULATIONS

GETTING STARTED
• Save the file NP_EX365_2021_9b_FirstLastName_1.xlsx as NP_EX365_2021_9b_FirstLastName_2.xlsx
o Edit the file name by changing “1” to “2”.
o If you do not see the .xlsx file extension, do not type it. The file extension will be added for you automatically.
• With the file NP_EX365_2021_9b_FirstLastName_2.xlsx open, ensure that your first and last name is displayed in cell B6 of the Documentation worksheet.
o If cell B6 does not display your name, delete the file and download a new copy.

PROJECT STEPS
1. Hwan Rhee is considering whether to start a software company called ChargeAll in Menlo Park, California, that will produce full-room wireless chargers for any type of mobile electronic device. Hwan is using an Excel workbook to analyze the financial data for a startup loan that will fund the parts and manufacturing of his product. He asks for your help in correcting errors and making financial calculations in the workbook.
Go to the Loan Analysis worksheet. Before Hwan can calculate the principal and interest payments on the loan, he asks you to correct the errors in the worksheet. Correct the first error as follows:
a. In cell D11, use the Error Checking command to identify the error in the cell.
b. Correct the error to calculate the monthly payment for the loan.
2. Correct the #DIV/0! errors in the worksheet as follows:
a. Use Trace Precedents arrows to find the source of the #DIV/0! error in cell G12.
b. Correct the formula in cell G12, which should divide the remaining principal (cell G11) by the loan amount (cell D6) to find the percentage of remaining principal.
c. Fill the range H12:K12 with the formula in cell G12 to correct the remaining #DIV/0! errors.
d. Remove any remaining trace arrows.
3. Now Hwan is ready to calculate the annual principal and interest payments for the startup loan. Start by calculating the cumulative interest payments as follows:
a. In cell G9, enter a formula using the CUMIPMT function to calculate the cumulative interest paid on the loan for Year 1 (payment 1 in cell G7 through payment 12 in cell G8). Use 0 as the type argument in your formula because payments are made at the end of the period.
b. Use absolute references for the rate, nper, and pv arguments, which are listed in the range D6:D12.
c. Use relative references for the start and end arguments.
d. Fill the range H9:K9 with the formula in cell G9 to calculate the interest paid in Years 2–5 and the total interest.
4. Calculate the cumulative principal payments as follows:
a. In cell G10, enter a formula using the CUMPRINC function to calculate the cumulative principal paid for Year 1 (payment 1 in cell G7 through payment 12 in cell G8). Use 0 as the type argument in your formula because payments are made at the end of the period.