Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Module 9 workbook answers

24/04/2021 Client: muhammad11 Deadline: 2 Day

New Perspectives Excel 2016 | Module 9: SAM Project 1a The Mobile Vegan FINANCIAL TOOLS AND FUNCTIONS GETTING STARTED • Open the file NP_EX16_9a_FirstLastName_1.xlsx, available for download from the SAM website. • Save the file as NP_EX16_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_EX16_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. 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 business, 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 business with an established clientele, she needs a loan to cover the cost of the trucks. She has asked for your help updating the workbook she created to analyze the loan information and forecast sales. Switch to the Loan Scenarios worksheet, and then calculate the monthly payment for the Add 1 Truck scenario as follows: 2. 3. a. In cell D11, enter a formula using the PMT function to calculate the monthly payment for a loan. b. Use the inputs listed under the Add 1 Truck loan scenario in cells D5, D7, and D9. (Hint: The result will be displayed as a negative number to reflect the negative cash flow of a loan payment.) Calculate the monthly interest rate for the Add 2 Trucks scenario as follows: a. In cell E7, enter a formula using the RATE function to calculate the monthly interest rate for a loan. b. Use the inputs listed under the Add 2 Trucks loan scenario in cells E9, E11, and E5. (Hint: Assume the present value of the loan is the loan amount shown in cell E5.) Calculate the loan amount for the Add 3 Trucks scenario as follows: New Perspectives Excel 2016 | Module 9: SAM Project 1a 4. 5. 6. a. In cell F5, enter a formula using the PV function to calculate the loan amount. b. Use the inputs listed under the Add 3 Trucks loan scenario in cells F7, F9, and F11. Calculate the number of months Jessica needs to pay back a loan for an existing food truck business 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 loan. b. Use the inputs listed under the Take Over loan scenario in cells G7, G11, and G5. Switch to the Amortization worksheet. Calculate the cumulative interest for a loan for one food truck as follows: a. In cell C17, enter a formula using the CUMIPMT function to calculate the cumulative interest paid on the loan 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 interest paid in Years 2–5. Calculate the cumulative principal for a loan 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. 7. In cell H18, use the Error Checking command to identify the error in the cell, and then correct the error.

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Coursework Helper
Chartered Accountant
Best Coursework Help
Top Class Results
Top Grade Essay
Smart Accountants
Writer Writer Name Offer Chat
Coursework Helper

ONLINE

Coursework Helper

I have read your project details. I can do this within your deadline.

$22 Chat With Writer
Chartered Accountant

ONLINE

Chartered Accountant

Hello, I an ranked top 10 freelancers in academic and contents writing. I can write and updated your personal statement with great quality and free of plagiarism

$49 Chat With Writer
Best Coursework Help

ONLINE

Best Coursework Help

Hello, I an ranked top 10 freelancers in academic and contents writing. I can write and updated your personal statement with great quality and free of plagiarism

$21 Chat With Writer
Top Class Results

ONLINE

Top Class Results

You can award me any time as I am ready to start your project curiously. Waiting for your positive response. Thank you!

$16 Chat With Writer
Top Grade Essay

ONLINE

Top Grade Essay

I am known as Unrivaled Quality, Written to Standard, providing Plagiarism-free woork, and Always on Time

$25 Chat With Writer
Smart Accountants

ONLINE

Smart Accountants

You can award me any time as I am ready to start your project curiously. Waiting for your positive response. Thank you!

$37 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Reaction time age graph - Phi 445 personal & organizational ethics - Terms of reference template - Nafta and mexican trucking case study answers - Strategic management MCQ - Power Point Presentation with a minimum of 12 slides - Cabin pressurizer units for sale - Leccion 4 panorama activities answers - Mini moke owners club uk - Paraphrase a noiseless patient spider - Research paper for Crypto - CRISIS - COURSE REFLECTION - Graphing reciprocal functions worksheet - Describe a memento which has an impact on your life - Managerial decision modeling with spreadsheets 3rd edition solutions - White light is composed of colours - Olongapo sports corporation distributes two premium golf balls - Overexposure in digital radiography - Body glove expanse ii fins - 3naoh h3po4 na3po4 3h20 - Watt converter to amp - Pediatric nursing Essay (NO PLAGIARISM) - Psych DB - Critical analysis/ discussion reply - Cat 5 colour code - Secrets of the parthenon summary - Asci 202 introduction to aeronautical science - Essay - Cloud computing failure case study - Uber greenlight hub tysons corner - Magnetic force on a loop of wire - Howard gardner designing education for understanding essay - Metric hi lo screws - Change cell to 20pt in excel - Concept Analysis Paper on a nursing topic in this case non compliant diabetic - Shoe box solar oven - Faust prologue in heaven - I need 1200 words on Young woman just got chosen to save a doomed fantasy world. - Operation Management  - Story bluffing questions and answers - Tpc v australian meat holdings - Soc 110 teamwork collaboration and conflict resolution - The norton introduction to literature portable 11th edition pdf - Caco3 hcl balanced equation - How to create an eportfolio using microsoft word - Need detail answer - Cloud Computing - Epa gov climatechange emissions ind calculator html - Oedipus rex short version - Sales tax office chennai address - The choice by edith wharton summary - Amadeus galileo sabre and worldspan - Power point - Head injury assessment form - My learning style paragraph - Anzia yezierska the lost beautifulness - Fahrenheit 451 car quotes - Rea model accounting information systems - Nacl conductivity in water - Unlike its competitors in the online air travel industry - Stage one of the issa drawing in phase is - Discussion - Can you buy individual proactiv products - Lutron wiring diagram uk - Knowledge Management - Article Summary and how organizational culture is used within your organization - Examples of comparison essay thesis statements - Identify and evaluate marketing opportunities answers - Blue bloater pink puffer - Consulting - Uber opportunities and threats in south africa - Computational errors in financial calculations - Does domino's deliver heart shaped pizzas - Discussion 2 - Soap note with differential diagnosis - Which theory is criticized for being too mechanistic - Assassin's creed odyssey photios pre retirement - Conditional probability venn diagram - Child family and community 7th edition pdf free download - Inventory normally has a debit balance true false - 4-5 slides - Health Communications ASSIGNMENT - Budgeting and control - Knee voltage of led - Coll 148 week 4 quiz - How does the marlin transcend his death - Frances glessner lee nutshell answers - For the record shi and mayer - Discussion Board International Business - Angel BPCC- Bio- Assignment 2 - How does food become compromised by microbes - Lessons learned from bsg game - 2011 pearson education inc - Nonfiction reading test garbage - Shanghai jiao tong university summer chinese language program - Organization development interventions case study - Create dangerously the immigrant artist at work sparknotes - Cie past papers french - Desert of song chords - I need a discussion - A copper refinery produces a copper ingot