You are a new hire at Laurel Woods Real Estate, which specializes in selling foreclosed homes via public auction. Your boss has asked you to use the following data (mortgage balance, monthly payments, payments made before default, and final auction price) on a random sample of recent sales to estimate what the actual auction price will be. Loan ($) Payments ($) Payments Made Auction ($) 85600 985.87 1 16900 115300 902.56 33 75800 103100 736.28 6 43900 84600 945.45 9 16600 97600 821.07 24 40700 104400 983.27 26 63100 113800 1075.54 19 72600 116400 1087.16 35 72300 100000 900.01 33 58100 92800 683.11 36 37100 105200 915.24 34 52600 105900 905.67 38 51900 94700 810.7 25 43200 105600 891.33 20 52600 104100 864.38 7 42700 85700 1074.73 30 22200 113600 871.61 24 77000 119400 1021.23 58 69000 90600 836.46 3 35600 104500 1056.37 22 63000 GIVEN - ALL CORRECT: Auction price =(118,929.46)+1.63 Loan +2.06 Monthly payment +50.34 Payments Made. ANOVA   Source DF SS MS F p-value Regression 3 5,966,725,061 1,988,908,354 39.83 0 Residual Error 16 798,944,439 49,934,027     Total 19 6,765,669,500     The excel data table is attached at the bottom (It is also correct). Rejected if t < -2.12 or t> 2.12 FIND:  If it seems one or more of the independent variables is not needed, remove it (them) and work out the revised regression equation. The revised regression equation is: Auction Price =____________ +_________ Loan.

Q: Suppose a mutual fund has total assets of $25,500,000 and liabilities of $2,100,000.  Currently…

A: given total assets =$ 25,500,000 liabilities =$ 2,100,000 shares outstanding =$ 10,200,000 to find…

Q: Consider a credit card with a balance of $8000 and an APR of 21%. If you want to make monthly…

A: According to the given data, find the total amount:

Q: What is the total cost of a house you purchased with $20,000 as a down payment and monthly payments…

A:

Q: A company reports the following income statement and balance sheet information for the current year:…

A: Given information, Net income = $114,590Interest expense = $9,963Average total assets = $1,859,000…

Q: Consider a credit card with a balance of $6000 and an APR of 16.99%. In order to pay off the balance…

A: Consider a credit card with a balance of  and an APR of .The balance pay off in years.To find the…

Q: Use this table to find the monthly mortgage payments, when necessary. Roberto has a mortgage of…

A:

Q: Betty Smith is the owner of Accurate Tax Service. For the year ending April 30, 2019, the following…

A: To prepare an income statement for Accurate Tax Service for the year ending April 30, 2019, we need…

Q: Which of the following discount rates will produce the smallest present value? Click here to view…

A:

Q: A bond has a 14000 face value, an 8 year maturity and a 3.05 coupon. Find the total of the interest…

A: Face value = 14000 Coupon = 3.05% Thus interest rate = 3.05% = 0.0305

Q: Calculate the net price of merchandise listing for $5,300 less a trade discount rate of 25%.   A.…

A: Given listing price  = $5,300 Trade discount rate = 25% First we have to find the net price factor…

Q: Kathy Hansen has a revolving credit account. The finance charge is calculated on the previous…

A: Given that: Annual percentage = 27% Fill the blanks in the table.   Month Previous Month's…

Q: You can afford a monthly payment of $375 for a new car loan.  You want the loan to last for 5 years…

A:

Q: Your employer is converting from a semimonthly pay period to biweekly pays. If you currently make…

A: To convert from a semimonthly pay period to a biweekly pay period, we can use the following formula…

Q: Suppose you see a car with a car with an advertised price of $14,500 at $410.83 per month for 4…

A: Given, Advertised price $14,500 at $410.83 per month for 4 years.

Q: Suppose a six-year bond is purchased for $5600. The face value of the bond when it matures is $7868.…

A: Suppose a six-year bond is purchased for $5600. The face value of the bond when it matures is…

Q: Calculate the net asset value (in $) and number of shares purchased for the mutual fund. Round…

A: This answer can be given by using formulas for net asset value and number of share purchased.

Q: Kathy Hansen has a revolving credit account. The finance charge is calculated on the previous…

A: Given:

Q: Consider a 30-year fixed-rate home loan of $525,500 with an interest rate of 3.75%. What is the…

A: We have to find the interest of given amount. The solution is following.

Q: Calculate the net asset value (in $) and number of shares purchased for the mutual fund. Round…

A: Net asset value=total assets - total Liabilities  Net asset value=$25,000,000-$6,500,000=$18,500,000…

Q: You are the loan department supervisor for a bank. This installment loan is being paid off early,…

A: Rebate fraction=(sum of the digit of the number of remaining payments)/(sum of the digit of the…

Q: As one of the loan officers for Grove Gate Bank, calculate the monthly principal and interest, PI…

A: For solving this given problem:

Q: $213,570 at 4.75​% interest and will pay ​$1,727 annual insurance premium. Her annual property tax…

A: monthly PITI payment consists of monthly mortgage,insurance and Tax.

Q: A man holds a note of ​$6,000 that has an interest rate of 15​% annually. The note was made on…

A: Given - A man holds a note of $6,000 that has an interest rate of 15​% annually. The note was made…