Module 9 SAM Project 1a | The Mobile Vegan | FINANCIAL TOOLS AND FUNCTIONS #newperspectives #module9
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, company and Management, company Math, company and money management, company and Accounting, Human Resource Management, History, English.
1. “You are a part-time manager for The Mobile Vegan, a food truck catering to vegan diners in Portland, Oregon. Jessica Rosen, the owner of the company, wants to expand by adding other food trucks in Portland and the surrounding area. Whether she purchases new trucks or takes over an existing food truck company with an established clientele, she needs a borrowing to cover the cost of the trucks. She has asked for your help updating the workbook she created to analyze the borrowing information and forecast sales.
Switch to the borrowing Scenarios worksheet, and then calculate the monthly payment for the Add 1 Truck scenario as follows:
a. In cell D11, enter a formula using the PMT function to calculate the monthly payment for a borrowing.
b. Use the inputs listed under the Add 1 Truck borrowing scenario in cells D5, D7, and D9. (Hint: The result will be displayed as a negative number to reflect the negative funds movement of a borrowing payment.)”
Create a formula using a function.
2. “Calculate the monthly borrowing charge rate for the Add 2 Trucks scenario as follows:
a. In cell E7, enter a formula using the RATE function to calculate the monthly borrowing charge rate for a borrowing.
b. Use the inputs listed under the Add 2 Trucks borrowing scenario in cells E9, E11, and E5. (Hint: Assume the present value of the borrowing is the borrowing amount shown in cell E5.)”
Create a formula using a function.
3. “Calculate the borrowing amount for the Add 3 Trucks scenario as follows:
a. In cell F5, enter a formula using the PV function to calculate the borrowing amount.
b. Use the inputs listed under the Add 3 Trucks borrowing scenario in cells F7, F9, and F11.”
Create a formula using a function.
4. “Calculate the number of months Jessica needs to pay back a borrowing for an existing food truck company as follows:
a. In cell G9, enter a formula using the NPER function to calculate how many months it would take to pay back a $500,000 borrowing.
b. Use the inputs listed under the Take Over borrowing scenario in cells G7, G11, and G5.”
Create a formula using a function.
5. “Switch to the Amortization worksheet. Calculate the cumulative borrowing charge for a borrowing for one food truck as follows:
a. In cell C17, enter a formula using the CUMIPMT function to calculate the cumulative borrowing charge paid on the borrowing after the first year (payment 1 in cell C15 through payment 12 in cell C16) 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 borrowing 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 borrowing for one food truck as follows:
a. In cell C18, enter a formula using the CUMPRINC function to calculate the cumulative principal paid in the first year (payment 1 in cell C15 through payment 12 in cell C16) 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 C18 to the range D18:G18 to calculate the principal paid in Years 2–5.”
Create a formula using a function.
Copy a formula into a range.
7. In cell H18, 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 the values in C18:G18 using the SUM function.)
Use Error Checking to find and correct an error.
new perspectives excel 2019 module 1 sam project 1a,new perspectives excel 2019 | module 1: end of module project 2,new perspectives excel 2019 module 2 end of module project 1,shelly cashman excel 2019 | module 1: sam project 1b,module 5 sam project 1a,new perspectives excel 2019,new perspectives word 2019 | module 10: sam project 1a,new perspectives excel,new perspectives excel 2019 | module 10: sam project 1b,module 1: sam project 1a,excel module 8 sam project
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.