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

10/11/2021 Client: muhammad11 Deadline: 2 Day

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

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:

Math Guru
Assignments Hut
Ideas & Innovations
Instant Assignment Writer
WRITING LAND
Quality Homework Helper
Writer Writer Name Offer Chat
Math Guru

ONLINE

Math Guru

I have done dissertations, thesis, reports related to these topics, and I cover all the CHAPTERS accordingly and provide proper updates on the project.

$31 Chat With Writer
Assignments Hut

ONLINE

Assignments Hut

I find your project quite stimulating and related to my profession. I can surely contribute you with your project.

$44 Chat With Writer
Ideas & Innovations

ONLINE

Ideas & Innovations

I am a professional and experienced writer and I have written research reports, proposals, essays, thesis and dissertations on a variety of topics.

$16 Chat With Writer
Instant Assignment Writer

ONLINE

Instant Assignment Writer

I have read your project details and I can provide you QUALITY WORK within your given timeline and budget.

$47 Chat With Writer
WRITING LAND

ONLINE

WRITING LAND

I have worked on wide variety of research papers including; Analytical research paper, Argumentative research paper, Interpretative research, experimental research etc.

$20 Chat With Writer
Quality Homework Helper

ONLINE

Quality Homework Helper

I am an experienced researcher here with master education. After reading your posting, I feel, you need an expert research writer to complete your project.Thank You

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

Characteristics of behavior aba - Ir spectrum of 2 methyl 2 butanol - 11 4 standardized test prep conditional probability - Database system - Form 1023 notification of incorrect answer s - Lintrose nominees pl v king - Discussion Topic - Climate technology centre and network - Outline & draft1 - What is observational learning - Anne reid doc martin - Year 12 formula sheet - Salvador dali frida kahlo relationship - The lucky hen learned ms - Chapter 2 summary of lord of the flies - Bernard centerfire parts breakdown - Creswell 2008 research design - At a certain location wind is blowing steadily - Head cook at weddings and funerals - How to win erpsim game - Direct medicine courier pharmacy - Smoove presents street beats - Social Work Discussion Questions - The secrets of house music production download - Case 3 walmart manages ethics and compliance challenges answers - The two internal dimensions represented on the axes of the space matrix are - Bread dough rising experiment - Triumph of the nerds part 1 summary - Killing us softly 4 free online - Pop stick bridge design - Probability Sampling and Nonprobability Sampling - How to reset kguard dvr to factory default - Mod Meters Case Study - Introduction to criminal justice lecture notes - WRITTEN ASSIGNMENT 2 - Sugu oishii sugoku oishii - Francesco boglione net worth - The house on mango street pictures - Prepare income statements for each year using absorption costing - Bank of ozarks mcdonough ga - Research paper Medical Terminology - Act government jobs gungahlin - After watching the video (We Still Live Here), answer the discussion questions below - Athletic shoe once endorsed by paula abdul - Leadership Behaviors - Industrial application of marcet boiler experiment - 100 spelling words for 5th grade - Enhance Security Policies with Multi-Factor Authentication. - Amisfield pinot noir 2012 - Research Paper - Proper adjectives examples sentences - Misleading and deceptive conduct examples - When you reach me discussion guide - How to do homework when sick - Onlinenationaledu - What is peel paragraph - Exponents square roots and scientific notation - Philosophy-Assignment W8 - Assignment #082 - Report 5 - Week 4 assignments - Lee valley tools vancouver catalogue - Jelly bean game target - Ass5 - Thesis statement on fake news - Bernie madoff case study - Is trevor noah's mom still alive - A rose for emily quiz answers - Pro eating disorder tumblr - 19 month developmental examiner's report - 8 hour security course albany ny - APA format paper on Academic integrity - How to treat baseball sliding burns - Integrated marketing communication case study with solution - Project management at six flags new jersey - Goods receiving process flow chart - How to make a salt bridge with filter paper - How facebook changed the world the arab spring summary - Why is derek miller's social media post different than most - Aldi green action eucalyptus oil multi-purpose cleaner - Trevor noah it's my culture dvd - Cash flow problems and solutions - Strategic management assignment - Prentice hall online textbook - Mile one seating chart hey rosetta - Dave hollis salary at disney - Which type of transformer is used in battery charger - Law Exam - Cahn ingold prelog rules priority - Operational Excellence (Assign) - Interstate battery date code - Ludlow medieval christmas festival - People styles at work assessment - ANATOMY AND PHYSIOLOGY - How are bays formed - Peter singer equality for animals summary - Cuchulainn's boyhood deeds summary - Org chat - The manager of a unit apartment complex - Lens equation practice problems