PLEASE HELP ASAP. Im on the verge of a breakdown with this homework. Question B$2$

Metropolis Hospital System now purchases a new equipment. Its cost is $$300,000$ and its useful life is $6$ years. Assume that the salvage value of this equipment is $$10,000$ if sold and get paid in year $7.$ Metropolis Hospital System anticipates that this equipment will generate net revenue of $$50,000$ in each of the $6$ years of service.

B$2\mathrm{.}1)$ Do a simple financial analysis using the Payback method $(5$ points$)$

ork back B$2\mathrm{.}2)$ Calculate the Accounting Rate of Return for this equipment. $(5$points$)16\mathrm{.}6\%$

B$2\mathrm{.}3)$ Now calculate the Internal Rate of Return $($IRR$).(10$ points$)32,3\%$

B$2\mathrm{.}4)$ Now use the Net Present Value method $($slide $14$ of lecture $17)$ to show that the IRR calculated in question B$2\mathrm{.}3$ satisfies the condition that IRR makes the net present value to be zero. $(10$ points$)$

Question B$3$

Suppose that you save $$300$ each month in a saving account for one year. The annual interest rate is $10\%.$ B$3\mathrm{.}1)$ You opt to deposit your saving at the beginning of the month. Calculate the future value of your total saving by the end of the year accordingly. $(10$ points$)$

B$3\mathrm{.}1)$ Now you opt to deposit your saving at the end of the month. Calculate the future value of your total saving by the end of the year accordingly. $(10$ points$)$

Question B$4(10$ points$)$

Amanda's financial future is bright after Clemson! She has a well$-$paid job. After paying all other expenses and substantial savings, she has about $$1,015$ left for monthly payment of a mortgage loan. Assume the annual interest rate is $6\%$ and the loan term is $15$ years, use the payment function $($PNF$)$ in Excel to calculate the right size of a mortgage loan she can borrow so that she can make monthly payment with het remaining income for loan payment.