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

On the loan worksheet in cell c9

17/03/2021 Client: saad24vbs Deadline: 3 days

Office 2013 – myitlab:grader – Instructions Exploring Series Vol. 2

Specialized Functions

Project Description: In the following project, you will use Excel to perform calculations regarding rental properties. You will create a basic search, utilize database functions, and create an amortization table

Instructions: For the purpose of grading the project you are required to perform the following tasks: Step Instructions Points Possible 1 Download and open the file named exploring_e07_grader_h1.xlsx, and then save the file as e07c2Apartment_LastFirst, replacing LastFirst with your name. 0 2 Insert functions in the Pet Deposit column of the Summary worksheet to calculate the required pet deposit for each unit. If the unit has two or more bedrooms and was remodeled after 2008 the deposit is $125, if not it is $75. 10 3 Enter nested functions in the Recommendation column to indicate Need to remodel if the apartment is unoccupied and was last remodeled before 2005. For all other apartments, display No change. 10 4 Type 101 in cell B2. 4 5 Insert a nested lookup function in cell E2 that will look up the rental price in column D using the apartment number referenced in cell B2. 10 6 Click the Database worksheet and enter conditions in the Criteria Range for unoccupied two- and three-bedroom apartments that need to be remodeled. 10 7 Perform an advanced filter based on the criteria range. Filter the existing database in place. 10 8 In cell C7, enter a DCOUNTA function to calculate the number of apartments to remodel. 6 9 In cell C8, enter a database function to calculate the total lost rent for the month. 2 10 Enter a database function to calculate the year of the oldest remodel in cell C9. 2 11 Click the Loan worksheet and enter 3/20/2015 in cell B7. 2 12 Insert a formula in cell E2 to calculate the loan amount based on the loan parameters in the input area. 2 13 Insert a formula in cell E3 to calculate the total number of periods. 2 14 Insert a formula in cell E4 to calculate the periodic monthly rate. 2 15 Insert a function in cell E5 to calculate the monthly payment. Ensure that the function returns a positive value. 2 16 In cell E6, insert a function to calculate the total interest paid on the loan. Ensure that the function returns a positive value. 2 17 Complete the loan amortization table for the first five payments only. In cell A11, enter 1. In cell B11, create a relative reference to cell B7 and in cell C11, create a relative reference to cell E2. Use the DATE function to complete the Payment Date column and financial functions for the Interest Paid and Principal Payment columns. In cell F11, enter =C11-E11. In cell C12, create a relative reference to cell F11. Note: Be sure to only complete the table through row 15. 18 18 Create a footer with the sheet name code in the center, and the file name code on the right side of each worksheet. 6 19 Save the file making sure the worksheets are in the following order: Summary, Database, and Loan. Close Excel. Submit the file as directed. 0 Total Points 100

Updated: 08/03/2013 1 E_CH07_EXPV2_H1_Instructions.docx

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:

University Coursework Help
Professional Coursework Help
Homework Guru
Essay & Assignment Help
Finance Master
Custom Coursework Service
Writer Writer Name Offer Chat
University Coursework Help

ONLINE

University 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

$115 Chat With Writer
Professional Coursework Help

ONLINE

Professional Coursework Help

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

$76 Chat With Writer
Homework Guru

ONLINE

Homework Guru

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

$79 Chat With Writer
Essay & Assignment Help

ONLINE

Essay & Assignment Help

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

$101 Chat With Writer
Finance Master

ONLINE

Finance Master

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

$49 Chat With Writer
Custom Coursework Service

ONLINE

Custom Coursework Service

I have read and understood all your initial requirements, and I am very professional in this task.

$104 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

Report on Ebola Epidemic in West Africa 2014 - General computer controls checklist - List of soliloquies in othello - Ranson attack assignment - Explain how the flexpath program aligns with your career goals - St augustine's primary school coffs harbour - 16 persic street largs north - Vehicle recovery training costs - Bantian huawei base longgang district shenzhen 518129 china - Let them eat dog literary analysis essay - Discussion Question:Leadership theories - ESL 546 - What is a common issue with social media marketing plans - 2003 chemistry hsc answers - Definition of imaginary audience - Strategic staffing handbook example - Primary care test bank - My ministry of pleasure - PROJECT 8- 500 WORDS AND PRATICAL CONNECT- 500 WORDS - Yeah buts live in the woods - Worldcom case study questions answers - Urgent 1 - Through the arc of the rainforest pdf - Virtual chemlab organic synthesis and qualitative analysis - Https beap gemini yahoo com - Practical connection paper on cloud computing - Data warehouse project template - Cisco packet tracer 6.2 tutorial - Compare and contrast essay introduction template - Mth 221 discrete math for information technology - Ancient greek number system - Mangerial Economics - Wild well control montrose - Convatec orahesive protective powder - Write an essay of at least 500 words discussing how database auditing and monitoring fit within a SOX compliance framework. - BUSN 2060 Corporate Responsibility - 4p - Actron air conditioner reset - Prayer for results of exams - Extracting salicylic acid from willow bark experiment - Classical approach to management - M4 Project: Autopsy Documentation Instructions - Unit test part 2 systems of equations - Triangle microworks iec 61850 - Lincoln college bear lane accommodation - 300 words APA format - Coulombic attraction worksheet answers - Sonnet 43 elizabeth barrett browning analysis - Tattoo machine armature bar setup - Guardian angels school gold coast - Mkt 100 assignment 2 situation analysis - Which of the following is an electrolyte - Example of ground state - Distinguish between absolute and comparative advantage - Summary of the alligator river story - Kwintessential co uk resources country profiles html - Research Digest - Health care issues are receiving much attention - The origin of ideas - Alliteration in annabel lee - Bsg final presentation ppt - Suppose there are 10 million workers in canada - Sex drugs and economics - How much does an elan system cost - Coastline credit union internet banking - Jack ma the art of dreaming and succeeding extraordinary pdf - Bsbmgt517 manage operational plan task 1 - Assignment - Los osos band director - Acara australian curriculum science - Which of the following bonds is the weakest - Monash university peninsula campus - Walking tracks mornington peninsula - Please allow at least 30 minutes within your exam time to upload your work. Once you have completed the assessment do not leave it to the last minute to upload. - Phet colorado circuit construction kit - Aaron maldonado oregon - Clark healthy workplace inventory - Virtual lab half life answer key - Books to teach inferencing - How to write a police incident report - 632.1 - Week 4 Discussion - Transitive dependency and partial dependency - Hay job evaluation system chart - G39 code of practice - Qr droid code generator - Discussion 1 wk 5 - Toyota prius target market segment - Power Point with strong reference - Business Ethics - Assigm 5 IPT - Powerpoint Presentation - The company has its camera and drone assembly facilities in - Data mining exam - 4 input nor gate truth table - What is par level in housekeeping - Smith & hawken estate size curled wreath white 30 - Does a grasshopper have an open or closed circulatory system - Assume the following information about the market and jumpmasters stock - Psychology