MAT 240 Module Three Assignment
.docx
keyboard_arrow_up
School
Southern New Hampshire University *
*We aren’t endorsed by this school
Course
MAT240
Subject
Finance
Date
Feb 20, 2024
Type
docx
Pages
4
Uploaded by MinisterSwanMaster994
Housing Price Prediction Model for D.M. Pan Real Estate Company
Dianna Sheely
Southern New Hampshire University
Median Housing Price Prediction Model for D.M. Pan National Real Estate Company
2
Module Two Notes
Region
State
County
listing price
$'s per square foot
square feet South Atlantic
FL
Miami-dade
$792,900.00 $164.84
4,810
South Atlantic
FL
Manatee
$707,400.00 $177.52
3,985
South Atlantic
FL
Brevard
$413,700.00 $169.76
2,437
South Atlantic
FL
Clay
$425,700.00 $176.79
2,408
South Atlantic
FL
Alachua
$265,400.00 $157.60
1,684
South Atlantic
FL
Marion
$560,200.00 $150.71
3,717
South Atlantic
FL
Lee
$391,900.00 $160.42
2,443
South Atlantic
FL
Citrus
$284,200.00 $176.96
1,606
South Atlantic
GA
Houston
$355,300.00 $154.08
2,306
South Atlantic
GA
Henry
$328,100.00 $155.57
2,109
South Atlantic
GA
Muscogee
$339,700.00 $163.63
2,076
South Atlantic
GA
Newton
$339,800.00 $188.78
1,800
South Atlantic
GA
Lowndes
$318,200.00 $133.70
2,380
South Atlantic
GA
Paulding
$348,200.00 $153.87
2,263
South Atlantic
GA
Liberty
$325,100.00 $187.49
1,734
South Atlantic
GA
Laurens
$275,900.00 $162.87
1,694
South Atlantic
NC
Franklin
$329,700.00 $176.22
1,871
South Atlantic
NC
Cleveland
$250,700.00 $149.14
1,681
South Atlantic
NC
Nash
$333,200.00 $189.53
1,758
South Atlantic
NC
Gaston
$441,500.00 $231.39
1,908
South Atlantic
NC
Brunswick
$281,000.00 $154.57
1,818
South Atlantic
NC
Lenoir
$399,900.00 $173.19
2,309
South Atlantic
NC
Cabarrus
$430,300.00 $178.55
2,410
South Atlantic
SC
Horry
$443,300.00 $205.80
2,154
South Atlantic
SC
Sumter
$291,900.00 $143.44
2,035
South Atlantic
SC
Darlington
$362,900.00 $205.14
1,769
South Atlantic
SC
Dorchester
$403,900.00 $164.19
2,460
South Atlantic
SC
Spartanburg
$375,100.00 $165.17
2,271
South Atlantic
SC
Cherokee
$374,100.00 $182.84
2,046
South Atlantic
SC
Lexington
$378,600.00 $198.95
1,903
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Related Questions
a. You are considering acquiring a building with a Dollar General as tenant and the following
financial terms and performance ratios (see graphic). You want to buy it at an 8.5 cap. What is your
offer, at the 8.5 cap? Show your work.
PROPERTY INFO
FINANCIAL SUMMARY
Tenant
Dollar General
Purchase Price
$1,519,661*
Street Address
511 Old Route 15
Cap Rate
6.80%
City
Port Trevorton
Net Operating Income
$103,337
State
PA
Price / SF
$167
Zip
17864
Rent/SF
$40
*Offering 2.5% Fee to Buy-Side Broker
APN
05-05-003
DOLLAR GENERAL
CONTACT INFORMATION
GLA
9,100 SF
Listing Agent
Nina McGaughy
Lot Size
1.31 AC
Phone Number
(424) 325-2624
Year Built
2019
INVESTMENT HIGHLIGHTS
Absolute Net (NNN) Investment
Dollar General operates on an Absolute Net (NNN) Lease with tenant fully responsible for maintenance,
insurance and taxes providing the landlord with a low maintenance asset
DOLLAR GENERAL
Corporate Guarantee
Dollar General Corporation (NYSE:DG) is a fortune 500 company with over 80 years in…
arrow_forward
Solve for the interest rate and the effective interest. The format is already given.
arrow_forward
ata table
K
Fabulous Fabricators needs to decide how to allocate space in its prod
year. It is considering the following contracts: E
a. What are the profitability indexes of the projed Data Table
b. What should Fabulous Fabricators do?
a. What are the profitability indexes of the projects?
The profitability index for contract A is
***
Contract
A
B
C
ck on the following icon in order to copy its contents into a spreadsheet.)
Use of Facility
100%
60%
40%
NPV
$1.98 million
$1.02 million
$1.53 million
(Round to two decimal places
arrow_forward
Help with 1. C please
arrow_forward
2
A family spends $46,000 a year for living expenses. If prices increase by 2 percent a year for the next three years, what amount will
the family need for their living expenses after three years? (Exhibit 1-A, Exhibit 1-B, Exhibit 1-C, Exhibit 1-D)
Check
arrow_forward
Topic 13: Renting versus Buying
123. Jennifer is choosing between buying a condominium property and renting it. The price for the
condo is $157,000. The financing terms, if the condo is purchased, are: LTV = 0.9, loan term = 30
years, interest rate = 5.75%, monthly payments. If the condo is purchased, it is subject to immediate
closing costs of $9,420. Further, projected property taxes are $2,400 per year, monthly association
fee is $160. If Jennifer decides to sell the purchased condo at some point of time in the future, such
sale will be subject to the agent's commission of 7 percent. If a similar condo is rented instead, the
current rent is $1,184.59 per month. If instead of buying a condo Jennifer chooses to rent, she will
invest money that otherwise would have been spent on condo into stock market. Assume that stock
market yields a 9 percent annual return. Compute the profit/loss of buying versus renting for
different periods of time spent in the purchased condo until it is sold…
arrow_forward
Using the findings provide a brief summary about the financial status of each of the companies and provide a recommendation for the investment choice.
arrow_forward
Fast answer Thank you!
arrow_forward
A 13.
Subject:- finance
arrow_forward
What is the amount of the total paid-in capital? What makes up this amount?
arrow_forward
Hw.8.
arrow_forward
Cleveland Foods Data Note: You can download
the Excel file containing Cleveland Foods' data
by clicking the above link and perform the
necessary calculations for answering the
upcoming questions. Question 12 (1 point) □
What is the unit contribution of BlueLiq,
considering the given information? $0.70 $2.50 $
1.00 $1.70
$
$
J
0
20% Retail Margin
2.50 Price to consumers (Retail Price)
15% Wholesale Margin
2.00 Price to retailers (Wholesale Price)
$
1.70 Price to Wholesalers
Variable Costs
$ 0.70 per unit
Fixed Costs
Variable Manufacturing Costs
$300,000 annual
$200,000 Corporate Overhead
$250,000 Marketing and Advertising
$750,000 Total Fixed Costs
Cleveland Foods Data
Fixed Manufacturing Costs
Note: You can download the Excel file containing Cleveland Foods' data by clicking
the above link and perform the necessary calculations for answering the upcoming
questions.
Question 11 (1 point).
Listen
4
What is the price at which Cleveland Foods sells BlueLiq to wholesalers?
$1.70
$2.50
$1.00
arrow_forward
6.
The monthly incomes for
12
randomly selected people, each with a bachelor's degree in economics, are shown on the right. Complete parts (a) through (c) below.
Assume the population is normally distributed.
4450.14
4596.62
4366.84
4455.36
4151.16
3727.41
4283.93
4527.14
4407.35
3946.01
4023.61
4221.66
(a) Find the sample mean.
arrow_forward
QUESTION 23
Ann wants to buy a building. The asking price is $7,500,000. Her lender has a
maximum LTV requirement of 85%. What is the minimum down payment Ann
needs to make in order to get this loan?
OA. $687,500
OB. $1,125,000
OC. $6,375,000
OD. $750,300
arrow_forward
id 1 :uonsenn siu i
29 o
Consider the following two projects:
Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Discount
Project C/F
Alpha
C/F
C/F
C/F
C/F
C/F
C/F
C/F
Rate
-79
20
25
30
35
40
N/A
N/A
12%
Beta
- 80
25
25
25
25
25
25
25
13%
The net present value (NPV) for project alpha is closest to:
A. $31
B. $25
OC. $21
D. $38
Click to select your answer.
MacE
esc
D00
O O O 0
arrow_forward
17
Using the figure below, calculate the percentage of revenue to the lender
based on the monthly construction draw schedule. The project assumes a
discount rate of 10%, and is for a 25-acre tract of land outside Lexington,
KY.
Construction
Sales Revenue
Month
Draw
(Lot Sales)
01234567899
509,600
0
327,600
0
327,600
0
327,600
0
109,200
226,100
109,200
226,100
109,200
226,100
0
455,525
0
455,525
0
455,525
0
455,525
The % of revenue to the lender is
O.137.4%
72.8%
131.2%
76.2%
arrow_forward
Analyze Cityscape Hotels
Cityscape Hotels has 200 rooms available in a major metropolitan city. The hotel is able to attract business customers during the weekdays and leisure customers during the weekend. However, the leisure customers on weekends occupy fewer rooms than do business customers on weekdays. Thus, Cityscape plans to provide special weekend pricing to attract additional leisure customers. A hotel room is priced at $180 per room night. The cost of a hotel room night includes the following:
Cost Per Room Night(at normal occupancy)
Housekeeping service
$23
Utilities
7
Amenities
3
Hotel depreciation
55
Hotel staff (excluding housekeeping)
42
Total
$130
The special weekend price is proposed for $120 per room night. At this price, it is anticipated that average occupancy for the weekend (Friday, Saturday, and Sunday) will increase from 30% to 50% of available rooms.
arrow_forward
Using the findings, provide a brief summary about the financial status of each of the companies and provide a recommendation for the investment choice.
arrow_forward
Don't give solution in image format..
arrow_forward
Good Day,
Kindly help me with the following:
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Essentials of Business Analytics (MindTap Course ...
Statistics
ISBN:9781305627734
Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:Cengage Learning
Related Questions
- a. You are considering acquiring a building with a Dollar General as tenant and the following financial terms and performance ratios (see graphic). You want to buy it at an 8.5 cap. What is your offer, at the 8.5 cap? Show your work. PROPERTY INFO FINANCIAL SUMMARY Tenant Dollar General Purchase Price $1,519,661* Street Address 511 Old Route 15 Cap Rate 6.80% City Port Trevorton Net Operating Income $103,337 State PA Price / SF $167 Zip 17864 Rent/SF $40 *Offering 2.5% Fee to Buy-Side Broker APN 05-05-003 DOLLAR GENERAL CONTACT INFORMATION GLA 9,100 SF Listing Agent Nina McGaughy Lot Size 1.31 AC Phone Number (424) 325-2624 Year Built 2019 INVESTMENT HIGHLIGHTS Absolute Net (NNN) Investment Dollar General operates on an Absolute Net (NNN) Lease with tenant fully responsible for maintenance, insurance and taxes providing the landlord with a low maintenance asset DOLLAR GENERAL Corporate Guarantee Dollar General Corporation (NYSE:DG) is a fortune 500 company with over 80 years in…arrow_forwardSolve for the interest rate and the effective interest. The format is already given.arrow_forwardata table K Fabulous Fabricators needs to decide how to allocate space in its prod year. It is considering the following contracts: E a. What are the profitability indexes of the projed Data Table b. What should Fabulous Fabricators do? a. What are the profitability indexes of the projects? The profitability index for contract A is *** Contract A B C ck on the following icon in order to copy its contents into a spreadsheet.) Use of Facility 100% 60% 40% NPV $1.98 million $1.02 million $1.53 million (Round to two decimal placesarrow_forward
- Help with 1. C pleasearrow_forward2 A family spends $46,000 a year for living expenses. If prices increase by 2 percent a year for the next three years, what amount will the family need for their living expenses after three years? (Exhibit 1-A, Exhibit 1-B, Exhibit 1-C, Exhibit 1-D) Checkarrow_forwardTopic 13: Renting versus Buying 123. Jennifer is choosing between buying a condominium property and renting it. The price for the condo is $157,000. The financing terms, if the condo is purchased, are: LTV = 0.9, loan term = 30 years, interest rate = 5.75%, monthly payments. If the condo is purchased, it is subject to immediate closing costs of $9,420. Further, projected property taxes are $2,400 per year, monthly association fee is $160. If Jennifer decides to sell the purchased condo at some point of time in the future, such sale will be subject to the agent's commission of 7 percent. If a similar condo is rented instead, the current rent is $1,184.59 per month. If instead of buying a condo Jennifer chooses to rent, she will invest money that otherwise would have been spent on condo into stock market. Assume that stock market yields a 9 percent annual return. Compute the profit/loss of buying versus renting for different periods of time spent in the purchased condo until it is sold…arrow_forward
- What is the amount of the total paid-in capital? What makes up this amount?arrow_forwardHw.8.arrow_forwardCleveland Foods Data Note: You can download the Excel file containing Cleveland Foods' data by clicking the above link and perform the necessary calculations for answering the upcoming questions. Question 12 (1 point) □ What is the unit contribution of BlueLiq, considering the given information? $0.70 $2.50 $ 1.00 $1.70 $ $ J 0 20% Retail Margin 2.50 Price to consumers (Retail Price) 15% Wholesale Margin 2.00 Price to retailers (Wholesale Price) $ 1.70 Price to Wholesalers Variable Costs $ 0.70 per unit Fixed Costs Variable Manufacturing Costs $300,000 annual $200,000 Corporate Overhead $250,000 Marketing and Advertising $750,000 Total Fixed Costs Cleveland Foods Data Fixed Manufacturing Costs Note: You can download the Excel file containing Cleveland Foods' data by clicking the above link and perform the necessary calculations for answering the upcoming questions. Question 11 (1 point). Listen 4 What is the price at which Cleveland Foods sells BlueLiq to wholesalers? $1.70 $2.50 $1.00arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Essentials of Business Analytics (MindTap Course ...StatisticsISBN:9781305627734Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. AndersonPublisher:Cengage Learning
Essentials of Business Analytics (MindTap Course ...
Statistics
ISBN:9781305627734
Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:Cengage Learning