The number of properties newly listed with a real estate agency in each quarter over the last four years is given below. Assume the time series has seasonality without trend. Quarter 1 2 3 4 Year 1 73 89 123 92 Year 2 81 87 115 95 Year 3 76 91 108 87 Year b. Solve for the estimated regression equation. c. Forecast the four quarters of Year 5. *Please solve in excel 4 77 88 120 97 a. Develop the optimization model that finds the estimated regression equation that minimize the sum of squared error.

Note:- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism. Answer completely. You will get up vote for sure.

Full explanation pls

Please complete this practice problem by using the 2 images below. Please write cleary and everything in order. Thank you

Round to the nearest whole number .

Sky High Partners is evaluating a high-rise office building to add to its investment portfolio. To calculate a value, Sky High plans to use the income approach, based on the following estimates: Gross potential yearly rental income Estimated vacancy rate Yearly operating costs Market capitalization rate a. Compute the net operating income (NOI) for the building. Net operating income $ Valuation $ 890,000 2.75% $ 417,000 14% 448,525 b. Using the income approach, calculate the value for the office building. Note: Round your answer to the nearest whole number.

Perform a present worth (PW)-based evaluation of the two alternatives below using a spreadsheet. The after-tax minimum acceptable rate of return (MARR) is 8% per year, Modified Accelerated Cost Recovery System (MACRS) depreciation applies, and Te=40%. The (GI -OE) estimate is made for the first 3 years; it is zero in year 4 when each asset is sold. Alternative First Cost, $ Salvage Value, Year 4, $ GI-OE, $ per Year Recovery Period, Years X -8,000 0 3,500 3 Y -13,000 2,000 5,000 3 The PW for alternative X is determined to be $ The PW for alternative Yis determined to be $ Alternative (Click to select) is selected.

Answer the given question with a proper explanation and step-by-step solution. Please provide the answer using the math tool otherwise I give the downvote.

please help!!!!!

Suppose that Project A has a life of 6 years and Project B has a life of 4 years. How many times (after the initial project life) would each project need to be repeated in order to conduct an analysis with the replacement change approach? O a. Project A would need to be repeated 5 times and Project B would need to be repeated 3 times b. Project A would need to be repeated 3 times and Project B would need to be repeated 5 times. c. Project A would need to be repeated twice and Project B would need to be repeated twice. O d. Project A would need to be repeated once and Project B would need to be repeated twice. e. Project A would need to be repeated once and Project B would need to be repeated once. O 1.