Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Question 22 3 H5 A fx Proposal for Dream Home Elijah and Valerie Foglesong 1 pts B C D E F G H J

image text in transcribed

Question 22 3 H5 A fx Proposal for Dream Home Elijah and Valerie Foglesong 1 pts B C D E F G H J K 4 Base House 5 Square footage: Main floor 6 Square footage: Basement 1,800 1,800 Table 1: Square Footage Total Sq Ft Base Cost 1,800 $144,000 Table 2: Square Footage & Lot Total Cost 7 Total Square footage 3,600 8 Base price per square foot $ 80.00 9 Base house price 10 11 Interior Upgrades 12 Granite countertops $ 13 Hardwood floors $ 7,500 14 Tile floors: main-floor bathrooms $ 3,200 15 Total interior upgrades $ 13,700 $ 288,000 3,000 2,000 $160,000 2,200 $176,000 $302,717 2,400 $ 192,000 $ 318,717 2,600 $208,000 $ 334,717 2,800 $ 224,000 $350,717 3,000 $240,000 $ 366,717 3,200 $256,000 $ 382,717 3,400 $272,000 $ 398,717 3,600 $288,000 $ 414,717 $270,717 $286,717 16 17 Exterior Upgrades 18 Complete sprinkler system $ 3,525 19 Fence $ 2,942 20 Energy efficient AC $ 3,875 21 Total exterior upgrades $ 10,342 22 23 Lot $ 102,675 24 25 Total Estimated Cost $ 414,717 26 If you wanted to compare the total Estimated Cost using a two variable data table based on both the square footage and cost of the lot, what value should be placed in cell H5(upper left cell of Table 2) =$B$9 =$B$25 =$B$23 Total Sq Ft

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

International Financial Management

Authors: Geert Bekaert, Robert J. Hodrick

2nd edition

013299755X, 132162768, 9780132997553, 978-0132162760

More Books

Students also viewed these Finance questions