An apartment complex is worth $2,000,000. Look up the 15 year rate in the WSJ. If...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
An apartment complex is worth $2,000,000. Look up the 15 year rate in the WSJ. If 10% of the value is put down, what would be the monthly payment? Use the S&P/Case-Shiller 20-City Composite Home Price Index (SPCS20RSA) data for the last 3 years to calculate the value of the property over the first 36 months. If the owners sell the property after the 36th payment, determine the NPV of the investment assuming a discount rate (cost of capital) of 4% a year. (remember you are looking to create a column of data that represents all the inflows and outflows over the 36 months). An apartment complex is worth $2,000,000. Look up the 15 year rate in the WSJ. If 10% of the value is put down, what would be the monthly payment? Use the S&P/Case-Shiller 20-City Composite Home Price Index (SPCS20RSA) data for the last 3 years to calculate the value of the property over the first 36 months. If the owners sell the property after the 36th payment, determine the NPV of the investment assuming a discount rate (cost of capital) of 4% a year. (remember you are looking to create a column of data that represents all the inflows and outflows over the 36 months).
Expert Answer:
Answer rating: 100% (QA)
The 15Year fixed mortgage rate according to WSJ is 285 The SPSC20RSA was 21336317 on 1 October 2018 and 27903308 on 1 October 2021 Last Updated Date T... View the full answer
Related Book For
Statistics Data Analysis and Decision Modeling
ISBN: 978-0132744287
5th edition
Authors: James R. Evans
Posted Date:
Students also viewed these accounting questions
-
Monthly rent at an apartment complex is $500. Operating costs average $15,000 per month regardless of the number of units rented. Construct a spreadsheet model to determine the profit if 35 units are...
-
Based on Problem 4-31, what would be your monthly payments if your mortgage amortization period was 20 years? 15 years? Data from problem 4-31: You have decided to become a homeowner with the...
-
Based on Exhibit 9-9 , what would be the monthly mortgage payments for each of the following situations? a. $40,000, 15-year loan at 5.5 percent. b. $76,000, 30-year loan at 6 percent. c. $65,000,...
-
Write a program to Sort the list U,N,I,V,E,R,S,I,T,Y in alphabetical order by Bubble sort I want the complete solution steps with the solution to the question
-
If you deposit %10,000 in a bank account that pays 10 percent interest annually, how much would be in your account after 5 years?
-
What are the major sources of consumer credit?
-
During its first year of operations, Atlas Travel earned revenue of $400,000 on account. Industry experience suggests that Atlas Travels uncollectible accounts will amount to 2% of revenues. On...
-
5. The state of Alaska was a tenant in a large office building owned by Univentures, a partnership. The state made a lease payment of $28,143.47 to Univentures with state treasury warrant No....
-
Megan turns 30 years old today. She currently has $25,000 in her account. She must make monthly deposits of $ beginning next month and ending on her 65th birthday (420 total deposits) in order to...
-
Students should read the Harvard Business School case study entitled 'Investments: Delineating an Efficient Portfolio' and answer the following questions. Students should note that the risk of the...
-
Purchase Invoices can be found in the Receivables Module. a) True b) False
-
Your firm is considering two one-year loan options for a $475,000 loan. The first carries fees of 1.8% of the loan amount and charges interest of 3.8% of the loan amount. The other carries fees of...
-
1. The radius of the Earth is 6370. [km]. (a) Calculate the linear speed at which a point on the Earth's surface at the Equator is moving because of the Earth's rotation. (b) Calculate the linear...
-
How do varying types of rewards (salary, bonuses, benefits, praise, opportunities for growth) interact with employee's internal sense of purpose, mastery, and autonomy? Can traditional incentive...
-
The auto repair shop of Quality Motor Company uses standards to control the labor time and labor cost in the shop. The standard labor cost for a motor tune-up is given below: Motor tune-up Standard...
-
Dana uses a rope to pull a box that weighs 300 lb across a level surface with constant velocity. The rope makes an angle of 60 above the horizontal and the tension in the rope is 100 lb. What is the...
-
write an algorithm (describe the steps) to calculate the total length of 3 highways Ontario. The three highways in Ontario are Highway 401, Highway 400, and Highway 407. Find the lengths of Highway...
-
Nate prepares slides for his microscope. In 1 day he prepared 12 different slides. Which equation best represents y, the total number of slides Nate prepares in x days if he continues at this rate? A...
-
What is a joint probability distribution? How are marginal probabilities calculated?
-
In the Excel file Gasoline Prices, determine if there is evidence to conclude that the variance of weekly prices during 2009 is less than 10%.
-
Explain the shadow prices for the GAC transportation model in Figure 13.12 in simple managerial terms.
-
Ski resorts are interested in the mean age that children take their first ski and snowboard lessons. They need this information to plan their ski classes optimally. identify: a. the population, b....
-
Insurance companies are interested in the mean health costs each year of their clients, so that they can determine the costs of health insurance. identify: a. the population, b. the sample, c. the...
-
A fitness center is interested in the mean amount of time a client exercises in the center each week. identify: a. the population, b. the sample, c. the parameter, d. the statistic, e. the variable,...
Study smarter with the SolutionInn App