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

In cell e15 enter a formula

21/12/2020 Client: saad24vbs Deadline: 2 Day

New Perspectives Excel 2013| Tutorial 9: SAM Project 1a




New Perspectives Excel 2013


Tutorial 9: SAM Project 1a


Wayside Driving School


EXPLORING FINANCIAL TOOLS AND FUNCTIONS


Project Goal


M Project Name


Project Goal



PROJECT DESCRIPTION

Emma Patterson is the owner of Wayside Driving School, and wants to expand operations into neighboring towns. To do so, she would need a loan to cover the costs of additional classroom space, vehicles, and instructors. Emma has asked you to create a detailed analysis of various expansion and financing options, complete with loan amortization and depreciation schedules. She also wants you to create a five-year sales forecast and income statement.


GETTING STARTED

· Download the following file from the SAM website:


· NP_Excel2013_T9_P1a_FirstLastName_1.xlsx


· Open the file you just downloaded and save it with the name:


· NP_Excel2013_T9_P1a_FirstLastName_2.xlsx


· Hint: If you do not see the .xlsx file extension in the Save file dialog box, do not type it. Excel will add the file extension for you automatically.


· With the file NP_Excel2013_T9_P1a_FirstLastName_2.xlsx still open, ensure that your first and last name is displayed in cell B6 of the Documentation sheet. If cell B6 does not display your name, delete the file and download a new copy from the SAM website.


PROJECT STEPS

Go to the Loan Analysis worksheet. In cell D12, use the PMT function to calculate the monthly payment for a loan using the inputs listed under the Add 1 Location 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).


In cell E7, enter a formula using the RATE function to calculate the monthly interest rate for a loan using the inputs listed under the Add 2 Locations loan scenario in cells E9, E12, and E5 (Hint: Assume the present value of the loan is the loan amount shown in cell E5).


In cell F5, enter a formula using the PV function to calculate the loan amount using the inputs listed under the Add 3 Locations loan scenario in cells F7, F9, and F12.


In cell G9, enter a formula using the NPER function to calculate how many months it would take to pay back a $1 million loan using inputs listed under the Expansion + BuyOut loan scenario in cells G7, G12, and G5.


Go to the Amortization worksheet. In cell C17, enter a formula using the CUMIPMT function to calculate the cumulative interest paid on the loan after the first year (payments 1 through 12) when the payments are made at the end of the period (Hint: Use 0 as the type argument in your formula). Use absolute references for the RATE, NPER, and PV arguments and relative references for the Start and End arguments. Copy the formula from cell C17 to the range D17:G17.


In cell H17, use the Error Checking command to identify the error in the cell, then correct the error (Hint: The formula in the cell should calculate the total the values in C17:G17 using the SUM function).


In cell C18, enter a formula using the CUMPRINC function to calculate the cumulative principal paid in the first year (payments 1 through 12) when the payments are made at the end of the period (Hint: Use 0 as the type argument in your formula). Use absolute references for the RATE, NPER, and PV arguments and relative references for the Start and End arguments. Copy the formula from cell C18 to the range D18:G18.


In cell E23, enter a formula that uses the PPMT function to determine the amount of loan payment number 1 devoted to the principal. Use absolute references for the RATE, NPER, and PV arguments and use cell A23 as the period argument (Hint: Remember that the period used in the formula is based on a monthly payment schedule). Copy the formula from cell E23 to range E24:E82.


In cell F23, enter a formula that uses the IPMT function to determine the amount of loan payment number 1 devoted to the interest. Use absolute references for the RATE, NPER, and PV arguments and use cell A23 as the period argument (Hint: Remember that the period used in the formula is based on a monthly payment schedule). Copy the formula from cell F23 to range F24:F82.


Go to the Depreciation worksheet. In cell C12, enter a formula that uses the SLN function to calculate the straight-line depreciation for the new vehicle fleet during the first year of service, with the value in cell D6 representing the expected life of the vehicle fleet. Use absolute references for the cost, salvage, and life arguments in the SLN formula. Copy the formula, without cell formatting, from cell C12 to the range D12:I12.


In cell C20, enter a formula that uses the DB function to calculate the declining balance depreciation for the new vehicle fleet during the first year of service, with the value in cell D6 representing the expected life of the vehicle fleet and the value in cell C19 as the current period. Use absolute references for the cost, salvage and life arguments in the DB formula and a relative reference for the period argument. Copy the formula from cell C20 to the range D20:I20.


Determine the error in cell D21 by using the Trace Precedent and Trace Dependent arrows. The formula in cell D21 should calculate the cumulative depreciation of the vehicle fleet by adding the Cumulative Depreciation value in year 1 to the Yearly Depreciation value in year 2. Correct the error in cell D21, copy the corrected formula in cell D21 to the range E21:I21, and then remove any arrows from the worksheet.


Go to the Income Statement worksheet. Project the revenues associated with the Classroom fees category for 2018-2020 (cells D5:F5) using a Growth Trend interpolation (Hint: Remember to select the range C5:G5 before filling this series with values).


Project the revenues associated with the Other category for 2018-2020 (cells D7:F7) using a Linear Trend interpolation (Hint: Remember to select the range C7:G7 before filling this series with values).


Project the expenses associated with the Payroll category for 2018-2021 (cells D11:G11) using a Growth trend extrapolation, using a step value of 1.07. (Hint: Remember that, when extrapolating values, the trend button in the Series Dialog Box should not be checked). Do not set a stop value for the series (Hint: Remember to select the range C11:G11 before filling this series with values).


Go to the Rate of Return worksheet and complete the following actions.


a. In cell E15, enter a formula that uses the NPV function to calculate the Present Value of the Add 1 Location investment, using the value in cell E14 as the desired rate of return and the range D7:D12 as the return paid to investors (Hint: If it appears, ignore the Formula Omits Adjacent Cell error warning).


b. In cell E16, enter a formula that calculates the Net Present Value by adding the Present Value of the Add 1 Location investment (calculated in cell E15) to the value of the initial investment (in cell D6).


In cell E17, enter a formula that uses the IRR function to calculate the internal rate of return of the Add 1 Location investment, using the range D6:D12 as the returns paid to the investors.


Your workbook should look like the Final Figures on the following pages. Save your changes, close the workbook, and exit Excel. Follow the directions on the SAM website to submit your completed project.


Final Figure 1: Loan Analysis Worksheet


Microsoft product screenshot reprinted with permission from Microsoft Incorporated. Copyright © 2014 Cengage Learning. All Rights Reserved.


Final Figure 2: Amortization Worksheet


Copyright © 2014 Cengage Learning. All Rights Reserved.



Final Figure 3: Depreciation Worksheet


Copyright © 2014 Cengage Learning. All Rights Reserved.



Final Figure 4: Income Statement Worksheet


Copyright © 2014 Cengage Learning. All Rights Reserved.



 Final Figure 5: Rate of Return Worksheet


Copyright © 2014 Cengage Learning. All Rights Reserved.


2


Applied Sciences

Architecture and Design

Biology

Business & Finance

Chemistry

Computer Science

Geography

Geology

Education

Engineering

English

Environmental science

Spanish

Government

History

Human Resource Management

Information Systems

Law

Literature

Mathematics

Nursing

Physics

Political Science

Psychology

Reading

Science

Social Science

Home

Blog

Archive

Contact

google+twitterfacebook

Copyright © 2019 HomeworkMarket.com

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:

Top Essay Tutor
Helping Hand
University Coursework Help
Writer Writer Name Offer Chat
Top Essay Tutor

ONLINE

Top Essay Tutor

I have more than 12 years of experience in managing online classes, exams, and quizzes on different websites like; Connect, McGraw-Hill, and Blackboard. I always provide a guarantee to my clients for their grades.

$40 Chat With Writer
Helping Hand

ONLINE

Helping Hand

I am an Academic writer with 10 years of experience. As an Academic writer, my aim is to generate unique content without Plagiarism as per the client’s requirements.

$35 Chat With Writer
University Coursework Help

ONLINE

University Coursework Help

Hi dear, I am ready to do your homework in a reasonable price.

$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

Autism practitioner job description - Harvey norman highpoint contact - Health and Human science 460 class - Looking for richard quotes - Which of the following statements is true about information - A localization strategy focuses on increasing profitability by - Reading Response - Brother ray ray charles own story pdf - Option for the poor and vulnerable - Washington company has the following stockholders equity accounts at - When hester and dimmesdale meet in the woods - Hadiya institute of colon hydrotherapy - Lincoln v205 tig welder - Directv no pip option - Impact of discrimination on individuals of multiracial backgrounds - Symbols in the great gatsby chapter 8 - If i told him gertrude stein - Energy flow in ecosystem ppt - Mbs mt eliza executive education - Loulou robert erwan larher - Product management plan template - Application for consent orders - Create a portfolio related to an Ecommerce Organization - What is expansion path in economics - Lead and manage effective workplace relationships case study - The talos principle wiki - Sophos management communications system - Combination criteria in the billing document - Osmolarity of 150 mm nacl - Distinguish between public debt and private debt - Manageability commander tool mesh edition - Peppa pig wii iso - Drug prevention program - Case information affidavit family court wa - Bird beak experiment worksheet - Ethics 445N - Chemical reaction of precipitation - Ucl medical school elective - Patho - Assignment W1 - How to find starch in a leaf - Artificial intelligence techniques in power systems ppt - Carlie c iga meat bundle prices - Montagu the lover a ballad - Australian healthcare & hospitals association - Understanding the impact of unmet social needs on consumer health and healthcare - Clausius clapeyron equation thermodynamics - Muslim Molvi 7340613399 OnLine No 1 FaMOUs VashIKaraN sPecIaLIsT IN Tirupati - Predictive Modeling Exercise - Vc dimension of rectangle - Project Management complexity - Apple vs samsung case study ppt - Soomo webtext answers - Sap hana case study pdf - Nvd nist gov 800 53 - Belle vale medical centre - Awesome is he chords - 1065 pittwater road collaroy - Sound audio manufactures and sells audio equipment - Francine rivers net worth - College Algebra Homework/Quiz **ASAP** - Each spot on the dna microarray in embedded with - Benchmark - Professional Capstone and Practicum Reflective Journal (TOPIC Fall prevention strategies in hospitals.) - LeadingGlobalandDiverseCultures_Assessment3 - Study llb at unisa - Discussion 7 - 700 words: Information Technology and Organizational Learning. Read the reference document and answer the questions in description - Lava dome volcano diagram - Red tag fire system - Jb hi fi monthly prize draw - Food and nutrition a level syllabus - City west homes lisson green - Compendium of sanitation systems and technologies - Learning agreement erasmus sapienza - Provide a 50-75 word discussion reply to the following post below. - One Paragraph Each - Hb fuller resistol - Read Carefully - Job order cost accounting system journal entries - Discussion - Cell membrane transport quiz - Geomancy symbols and meanings - PRETORIA ABORTION CLINIC +27717852514 ABORTION PILLS FOR SALE IN MAMELODI, PRETORIA, ATTERIDGEVILLE, ACADIA, SUNNYSIDE, - Scully corporation's comparative balance sheets are presented below - Relationship between professional practices and scholarly ethics - Write a journal about Muslim countries - Jims gym verb tense - Roosevelt speak softly and carry a big stick - Does nitrogen have lone pairs - Ocga 16 5 20 simple assault - Shadow health focused exam chest pain - Stop 12 belair rd east side - Vocabulary - Award maps university of northampton - For each drawing, you will hear two statements. choose the one that corresponds to the drawing. - Angela's story a case study on the reproductive system answers - Which of the following statements best describes scientific research - The prokaryotic cells that built stromatolites are classified as _____ - Center pivot design program - Boo yaa tribe wack 100 - Killing us softly 4 transcript