Please choose your own dream car and construct amortization schedule in excel. I provide the template format for your excel. You should construct with formula in excel. You can choose your own loan amount, down payment, maturity $(5$ year, monthly payment$),$ and interest rate as $6$ percent annual rate $($monthly periodic interest rate is $6/12=0\mathrm{.}5\%$

Loan Amortization Schedule lamborghini aventador price

Car Price $328,899$ Euro $255,000\mathrm{.}001$ euro $=1\mathrm{.}2898$ US dollars

Down payment $28,899$

Loan Amount $300,000$

Interest $6\mathrm{.}000\%0\mathrm{.}005$

Term $10120$

Monthly Payment $$3,330\mathrm{.}62$

Total Payment $$3,330\mathrm{.}62$

Month Beginning PMT Interest Principle Additional PrinEnding Balance

$1300,000\mathrm{.}00$ $$3,330\mathrm{.}621,500\mathrm{.}001,830\mathrm{.}620298,169$

$2298,169\mathrm{.}38$ $$3,330\mathrm{.}621,490\mathrm{.}851,839\mathrm{.}770296,330$

$3296,329\mathrm{.}62$ $$3,330\mathrm{.}621,481\mathrm{.}651,848\mathrm{.}970294,481$

$4294,480\mathrm{.}65$ $$3,330\mathrm{.}621,472\mathrm{.}401,858\mathrm{.}210292,622$

$5292,622\mathrm{.}44$ $$3,330\mathrm{.}621,463\mathrm{.}111,867\mathrm{.}500290,755$

$6290,754\mathrm{.}94$ $$3,330\mathrm{.}621,453\mathrm{.}771,876\mathrm{.}840288,878$

$7288,878\mathrm{.}09$ $$3,330\mathrm{.}621,444\mathrm{.}391,886\mathrm{.}220286,992$

$8286,991\mathrm{.}87$ $$3,330\mathrm{.}621,434\mathrm{.}961,895\mathrm{.}660285,096$

$9285,096\mathrm{.}21$ $$3,330\mathrm{.}621,425\mathrm{.}481,905\mathrm{.}130283,191$

$10283,191\mathrm{.}08$ $$3,330\mathrm{.}621,415\mathrm{.}961,914\mathrm{.}660281,276$

$11281,276\mathrm{.}42$ $$3,330\mathrm{.}621,406\mathrm{.}381,924\mathrm{.}230279,352$

$12279,352\mathrm{.}19$ $$3,330\mathrm{.}621,396\mathrm{.}761,933\mathrm{.}850277,418$

$13277,418\mathrm{.}33$ $$3,330\mathrm{.}621,387\mathrm{.}091,943\mathrm{.}520275,475$

$14275,474\mathrm{.}81$ $$3,330\mathrm{.}621,377\mathrm{.}371,953\mathrm{.}240273,522$

$15273,521\mathrm{.}57$ $$3,330\mathrm{.}621,367\mathrm{.}611,963\mathrm{.}010271,559$

$16271,558\mathrm{.}56$ $$3,330\mathrm{.}621,357\mathrm{.}791,972\mathrm{.}820269,586$

$17269,585\mathrm{.}74$ $$3,330\mathrm{.}621,347\mathrm{.}931,982\mathrm{.}690267,603$

$18267,603\mathrm{.}05$ $$3,330\mathrm{.}621,338\mathrm{.}021,992\mathrm{.}600265,610$

$19265,610\mathrm{.}45$ $$3,330\mathrm{.}621,328\mathrm{.}052,002\mathrm{.}560263,608$

$20263,607\mathrm{.}89$ $$3,330\mathrm{.}621,318\mathrm{.}042,012\mathrm{.}580261,595$

$21261,595\mathrm{.}32$ $$3,330\mathrm{.}621,307\mathrm{.}982,022\mathrm{.}640259,573$

$22259,572\mathrm{.}68$ $$3,330\mathrm{.}621,297\mathrm{.}862,032\mathrm{.}750257,540$

$23257,539\mathrm{.}93$ $$3,330\mathrm{.}621,287\mathrm{.}702,042\mathrm{.}920255,497$

$24255,497\mathrm{.}01$ $$3,330\mathrm{.}621,277\mathrm{.}492,053\mathrm{.}130253,444$

$25253,443\mathrm{.}88$ $$3,330\mathrm{.}621,267\mathrm{.}222,063\mathrm{.}400251,380$

$26251,380\mathrm{.}48$ $$3,330\mathrm{.}621,256\mathrm{.}902,073\mathrm{.}710249,307$

$27249,306\mathrm{.}77$ $$3,330\mathrm{.}621,246\mathrm{.}532,084\mathrm{.}080247,223$

$28247,222\mathrm{.}69$ $$3,330\mathrm{.}621,236\mathrm{.}112,094\mathrm{.}500245,128$

$29245,128\mathrm{.}19$ $$3,330\mathrm{.}621,225\mathrm{.}642,104\mathrm{.}970243,023$

$30243,023\mathrm{.}21$ $$3,330\mathrm{.}621,215\mathrm{.}122,115\mathrm{.}500240,908$

$31240,907\mathrm{.}72$ $$3,330\mathrm{.}621,204\mathrm{.}542,126\mathrm{.}080238,782$

$32238,781\mathrm{.}64$ $