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

Stromag ag limit switch - Russian stacking dolls name - John lewis harmony ribbon pendant - Sop for digital marketing course - Structure of the book thief - Asic v rich case summary - Fish creek vet prices - Paulson company issues 6 four year bonds - Catholic schools office pennant hills - English 102 research paper example - Diffusion experiment potassium permanganate - Discussion Post-IT to the cloud - Square root of 55 - Types of managed care organizations - Cisco business edition 7000 ordering guide - Adding ly rules powerpoint - Of the four marketing functions, where does it look like most of the jobs are? What are the specific positions? How are the other marketing functions conducted through those job positions, even though in a smaller way? - How to calculate preliminary cash balance - Gormally property management galway - 1/20 as a percentage - Storytelling from prehistoric caves to modern cinemas answers - PR /Media sporting event - Faculty of science helwan university - Extended style question - Latin alphabet pronunciation audio - First normal form definition - One 3 Part Lecture Question DUE SATURDAY 10/24 @ 12PM EST!!! 300 - 400 Words!! - Travel broadens the mind argumentative essay - Configuration manager remote control service - Brawn behind the pawn book - 1.18 unit test the study of chemistry part 1 - How to think like an anthropologist sparknotes - Acc 250 week 1 assignment - Walmart failure in germany ppt - Unit viii dq mba 6001 - Author of wizard of oz - Allotrope of oxygen crossword - Leece neville alternator troubleshooting - Understanding year 4 maths - Nyx medical billing company in bangalore - 632wk5d2 - Project requirements risk cost paper - The white company is a member of the lamp industry - Lesley university bursar - Emoji book titles answers - Internet for it governance planning - Consultation skills for pharmacy practice practice standards for england - How to install mariadb on windows - Difference between atom and molecule in dell boomi - Which of the following situations would be considered cyclical unemployment? - Absolute power to control the internet and its content - Chemistry - Jb hi fi mobile phone insurance - Cypress college course catalog - Meaning of lesson plan in arabic - Why Amazon is Worth $1 Trillion - Topic: The League of Iroquois Constitution and Government - Jetson tk1 development kit - Cyber bullying homework - Please see attached my - Martin hagan neural network design - Ethical lens inventory blind spot - Goneril poisons regan quote - Advantages of hindu arabic number system - Article - How to apply ptptn for second time - Four frames of organization examples - Aluminum metal or nonmetal - Phet waves on a string answer key - Danske bank sort code - Acc 202 final project presentation to investors - Assisments - Business and society 15th edition pdf - Physics principle and applications 7e giancoli test bank - 500 word Research Report - Broadbill corporation a calendar year c corporation - Ginny's restaurant an introduction to capital investment valuation - Canal and river trust gold licence - Eco 550 assignment 2 operations decision - Katerina ivanovna crime and punishment - WEEK II PART1 - Horror text effect photoshop - File allocation table ppt - Shaver manufacturing inc offers dental insurance to its employees - Nixe mackerel fillets in tomato sauce syns - Degree office management uitm - When does hansberry visit her grandmother - Jumbled words with answers - What are jamie olivers childrens names - Information system architecture definition - Key selection criteria responses - The burning of 80.3 g of sih4 - Middle ground argument essay - Leadership theories matrix ldr 300 - Pilot implementation plan template - Lesson 2 discussion CAM - Why do firms use cross border strategic alliances - Risk management post test - Aspenone v8 8 download - Before the renaissance virtually all dramas focused on