Module 9: SAM Project 1b | Danbury Drop-In Clinics | FINANCIAL TOOLS AND FUNCTIONS #newperspectives
If you directly want to get the project from us then contact us on our Whatsapp. Link is given here,
Whatsapp Contact Link:
https://api.whatsapp.com/message/4B6NMKKBKUFYN1?autoload=1&app_absent=0
Whatsapp Number:
+919116641093
+918005564456
Gmail Id:
singhal.agrawal.bharati@gmail.com
We are providing help in all Online Courses, Computer Science, enterprise and Management, enterprise Math, enterprise and financial, enterprise and Accounting, Human Resource Management, History, English.
1. “You are an office assistant for the Danbury Drop-In Clinic, a walk-in healthcare clinic in Danbury, Connecticut. Daniel Boyette, the owner of the clinic, wants to expand by adding other clinic locations in Danbury. Whether he leases new space or merges with another clinic, he needs a debt to cover the cost of the clinics. He has asked for your help updating the workbook he created to analyze the debt information and forecast sales.
Switch to the debt Scenarios worksheet, and then calculate the monthly payment for the Add 1 Location scenario as follows:
a. In cell D10, enter a formula using the PMT function to calculate the monthly payment for a debt.
b. Use the inputs listed under the Add 1 Location debt scenario in cells D4, D6, and D8. (Hint: The result will be displayed as a negative number to reflect the negative financial liquidity of a debt payment.)”
Create a formula using a function.
2. “Calculate the monthly finance charge rate for the Add 2 Locations scenario as follows:
a. In cell E6, enter a formula using the RATE function to calculate the monthly finance charge rate for a debt.
b. Use the inputs listed under the Add 2 Locations debt scenario in cells E8, E10, and E4. (Hint: Assume the present value of the debt is the debt amount shown in cell E4.)”
Create a formula using a function.
3. “Calculate the debt amount for the Add 3 Locations scenario as follows:
a. In cell F4, enter a formula using the PV function to calculate the debt amount.
b. Use the inputs listed under the Add 3 Locations debt scenario in cells F6, F8, and F10.”
Create a formula using a function.
4. “Calculate the number of months Daniel needs to pay back a debt for an existing clinic as follows:
a. In cell G8, enter a formula using the NPER function to calculate how many months it would take to pay back a $450,000 debt.
b. Use the inputs listed under the Merger debt scenario in cells G6, G10, and G4.”
Create a formula using a function.
5. “Switch to the Amortization worksheet. Calculate the cumulative finance charge for a debt for one new clinic location as follows:
a. In cell C16, enter a formula using the CUMIPMT function to calculate the cumulative finance charge paid on the debt after the first year (payment 1 in cell C14 through payment 12 in cell C15) when the payments are made at the end of the period. Use 0 as the type argument in your formula.
b. Use absolute references for the rate, nper, and pv arguments.
c. Use relative references for the start and end arguments.
d. Copy the formula from cell C16 to the range D16:G16 to calculate the finance charge paid in Years 2–5.”
Create a formula using a function.
Copy a formula into a range.
6. “Calculate the cumulative principal for a debt for one new clinic location as follows:
a. In cell C17, enter a formula using the CUMPRINC function to calculate the cumulative principal paid in the first year (payment 1 in cell C14 through payment 12 in cell C15) when the payments are made at the end of the period. Use 0 as the type argument in your formula.
b. Use absolute references for the rate, nper, and pv arguments.
c. Use relative references for the start and end arguments.
d. Copy the formula from cell C17 to the range D17:G17 to calculate the principal paid in Years 2–5.”
Create a formula using a function.
Copy a formula into a range.
7. In cell H17, use the Error Checking command to identify the error in the cell, and then correct the error. (Hint: The formula in the cell should calculate the total values in C17:G17 using the SUM function.)
new perspectives excel 2019 module 1 sam project 1a,new perspectives excel 2019 | module 1: end of module project 2,shelly cashman excel 2019 | module 1: sam project 1b,new perspectives excel 2019 module 2 end of module project 1,module 5 sam project 1a,new perspectives word 2019 | module 10: sam project 1a,new perspectives excel 2019,new perspectives excel 2019 | module 10: sam project 1b,new perspectives excel,excel module 8 sam project,excel module 5 sam project a
Disclaimer:
If you own the YouTube channel related to this video and do not want it to be featured here, you can contact us through our contact page. We will gladly remove it without questioning your reasons.