$1$ Post Date Note$204/01/2024$ Interest Payment$302/29/2024$ Interest Payment$402/23/2024$ Transfer to Checking$501/30/2024$ Interest Payment$601/10/2024$ Transfer to Checking$701/02/2024$ Interest Payment$811/30/2023$ Interest Payment$911/29/2023$ Transfer to CheckingA$1010/30/2023$ Interest Payment$1110/02/$I$2023$ Interest Payment$1208/30/2023$ Interest Payment$1308/28/2023$ adv on loan$1407/31/2023$ Interest Payment$1506/30/2023$ Interest Payment$1605/25/2023$ Loan Advance$1705/25/2023$ Loan Advance$181920212223$Debit$72,000\mathrm{.}21$$ $58,647\mathrm{.}2549,856\mathrm{.}22$$$256,231\mathrm{.}22$$ $73,200\mathrm{.}71$$ $50,545\mathrm{.}37$$ $560,480\mathrm{.}98$DCredit Status$$3,180\mathrm{.}36$ Posted$$2,844\mathrm{.}10$ PostedPosted$$2,723\mathrm{.}87$ PostedPosted$$2\mathrm{.}421\mathrm{.}79$ Posted$$2,140\mathrm{.}17$ PostedPosted$$2,071\mathrm{.}13$ Posted$$2\mathrm{.}231\mathrm{.}50$ PostedPosted$ $701,23$ Posted$ $888\mathrm{.}21$ PostedPostedPostedLoanBikeCarBikeBikeFTruckVanHNext Payment DateCurrent BalanceOriginal Loan AmountLast Loan PaymentInterest RateLoan TermOriginal Loan Date$$59$ Months$30-$Apr$-24560\mathrm{.}480\mathrm{.}98700,000\mathrm{.}003,500\mathrm{.}207\mathrm{.}00\%5/10/2023$There are $4$ loans that need an amortization schedule alongwith the dates the funds advanced.Build a report that shows how much to allocate to each loanper month. The interest will need to be posted to the correctvehicle for each of the moths Jan$-$April.When you've finished the math, put it into an Excel documentand show your wWork.Please have this done soon and ensure that it is submitted tomy email.$ $724\mathrm{.}60$ Posted