Study Help Me
Study Help Me
Study Help Me


question archive Excel chapter 7 grader project Chapter 7 Capstone Project   Project Description: In this project, you will use Excel to perform calculations regarding rental properties

Excel chapter 7 grader project Chapter 7 Capstone Project   Project Description: In this project, you will use Excel to perform calculations regarding rental properties

Subject:MS ExcelPrice:19.87 Bought3

Excel chapter 7 grader project

Chapter 7 Capstone Project

 

Project Description:

In this project, you will use Excel to perform calculations regarding rental properties. You will create a basic functions, 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.000

2

Insert functions in the Pet Deposit column of the Summary worksheet to calculate the required pet deposit for each unit. If the unit was remodeled after 2008 and has two or more bedrooms, the deposit is $125; if not, it is $75.

10.000

3

Enter nested functions in the Recommendation column to indicate Need to remodel if the apartment is unoccupied and was last remodeled before 2005. Display No change for all other apartments.

10.000

4

Type 101 in cell B2.

4.000

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.000

6

Click the Database worksheet and enter conditions in the Criteria Range for unoccupied two- and three-bedroom apartments that need to be remodeled. Enter Need to remodel in the Recommendation column for these rows.
 

10.000

7

Perform an advanced filter based on the Criteria range. Filter the existing database in place.

10.000

8

In cell C7, enter a DCOUNTA function to calculate the number of apartments to remodel using the existing Criteria range name.

6.000

9

In cell C8, enter a database function to calculate the total lost rent for the month using the Criteria range.

2.000

10

Enter a database function to calculate the year of the oldest remodel in cell C9.

2.000

11

Click the Loan worksheet and enter 3/20/2015 in cell B7.

2.000

12

Insert a formula in cell E2 to calculate the loan amount based on the loan parameters in the input area.

2.000

13

Insert a formula in cell E3 to calculate the total number of periods.

2.000

14

Insert a formula in cell E4 to calculate the periodic monthly rate.

2.000

15

Insert a function in cell E5 to calculate the monthly payment. Ensure that the function returns a positive value.

2.000

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.000

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. Be sure to only complete the table through row 15.

18.000

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.000

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.000

 

Total Points

100.000

Option 1

Low Cost Option
Download this past answer in few clicks

19.87 USD

PURCHASE SOLUTION

Option 2

Custom new solution created by our subject matter experts

GET A QUOTE

rated 5 stars

Purchased 3 times

Completion Status 100%

Related Questions

assignment helpassignment helperassignment expertsassignment writing services