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

Royal glamorgan hospital map - How do i find the volume of a cuboid - Ceo of woolworths australia - Grand strategy business - Advantages of a multicultural society and labor force - Null space of transpose - Swot analysis of mcdonalds 2017 - The developing person 10th edition pdf - Quotes from to kill a mockingbird chapter 1 - Unit viii table of dirty tricks - A life cycle of a wolf - Cpalms 119030 - Independent university bangladesh tuition fees - Mccormack mccance 2010 person centred nursing - Experience the big book - Importance of consumer behaviour ppt - Roll ring chain tensioner - Week Five Discussion One - Nebosh igc element 1 foundations in health and safety notes - Alibaba organizational design - How many syllables does snake have - Using currents to sail around the world - Pre lab assignment 1 osmosis and tonicity practice problems - GPU Databases (Kinetica, SQream, BlazingDB, Omnisci etc) - Online job portal project documentation in php pdf - Equifinality in systems theory - The wrong bachelor alexandra moody vk - Derbyshire county council blue badge - Chemistry lab introduction to measurement answers - Roar lyrics figurative language - Q4 bas due date - Work Sheet Connector "Amal Unbound" by Aisha Saeed - Describe your current ecological footprint - Java coding - Alignment of IT Strategy and Business Strategy- Case - Audit procedures for bad debts - The cottage at coquet meadows - Difference between ethical dilemma and ethical issue - Pa state police southwest training center - Four elements of fitness programs issa - Business intelligence question - Bullying essay - Horus egyptian god jesus - Seismic design of building structures ppt - Economics - Student Loan Debt Policy - Question : Assignment - Interrater and intrarater reliability - Forecasting interview questions - Skewness of a histogram - Potassium acid phthalate msds - How to find the median on a casio calculator - Assignment Week 6 - External equity in hrm - Acct 212 course project - What is a courtroom work group - Extra points - How many sigma and pi bonds in co2 - Capstone chap1 - A nurse is reviewing the daily intake and output - Giving toddlers choices is considered to be developmentally inappropriate - I lost my homework in a cave somewhere - Roland pinch roller sensor - Financial review newspaper price - Euclid v ambler realty case brief - 1/3 mgmt - Are macquarie bank capital notes 2 a good investment - Sccm remote control viewer - A level biology exam questions by topic cie - Burke litwin model strengths and weaknesses - Woody guthrie dust bowl ballads lyrics - Lexi from vampire diaries - Edld 5311 fundamentals of leadership - French future tense endings - Child case study assignment - Material index ces edupack - Institute of credit management kenya - Free transform tool indesign - How to demonstrate active transport - PSYC Life Span Development Psychology - 23 south wharf promenade south wharf vic 3006 - Silicon tetrachloride can be prepared by heating - The flowers by alice walker theme - 7 problem solving techniques ppt - Color music children's choir wikipedia - Bk pop medical abbreviation - Sephadex g 50 column - A people's history of the united states chapter 1 questions - Sunshine coast cricket association website - Air canada organizational structure - How to read solubility chart - Maybe it's true i can t live without you - Examples of centripetal and centrifugal forces - Chapter 3 jekyll and hyde - Ps music balance sheet - Describe your favourite book - Key and peele army running cadence - Palindrome computer science - Costco singapore math - Practical strategies for technical communication edition 2