Andreas borrows some money to buy a new car. The car dealership allows her to defer$($delay$)$ payments for $12$ months, and makes $48$ end$-$ofmonth payments thereafter. If the original note $($loan$)$ is for $$28,000$ and interest in $0\mathrm{.}5\%$ per month on the unpaid balance,

a$-)$ how much will Andreas payment be$?$

b$-)$ For that question assume that the initial investment of $$42,000,000$ will be funded using a mix of debt and equity financing.

b$-1$ Calculate the NPV$,$ LCOE, IRR and the breakeven period of the investment by assuming a $50\%$ debt ratio, i$.$e$.,$ half of initial investment is financing trough debt and $50\%$ through equity. To answer, make sure that you give a dedicated cell to the debt ratio, $0\mathrm{.}5$ or $50\%$ in the current case, and make sure to calculate annual total payment and annual interest payment for each year. Structure your excel file so that you can get automatic NPV$,$ LCOE and IRR calculations by changing the debt ratio in the dedicated cell.

b$-2$ Calculate NPV for different values of the debt ratio of your choosing. Do you observe that there is an optimum debt ratio for this investment?