Amountsforthequarter:SalesbudgetBudgetedcashcollectionsBudgetedpurchasesBudgetedcashpayments-purchasesEndingCashBalanceIncStmtInterestExpenseIncStmtNetincomeBalSheetARBalSheetInventoryBalSheetAPBalSheetRetainedEarnings(RE)BalSheetTotalAssets(=Liab+OE)$17,715,600$13,449,500$11,262,240$10,760,200$599,219$7,181$5,112,319$7,115,100$2,708,640$1,580,040$8,657,719Scenario2$10,653,759 "MEMO; interest expense calculabion: MEMO: interest expense on amount borrowed in 2 nd month: To help you caloulate interest and round the amount total amount borrowed in 2 nd month to the nearest dolac, formulas are provided in the yellow cells. rate per year intecest for 12 months 5 number of months in a year interest for 1 month 5 months outstanding total interest expense for this amount ENIER AMOUNIS FROM CASH BUDGET HERE (II any) CHANGE YOUR RATE HERE Y diPnRent Interest expense on amount borrowed in 1st month: total amount borrowed in 1 st month rate per year interest for 12 months 5 number of months in a year interest for 1 month 5 months outstanding total interest expense for this amount ENTER AMOUNTS FROM CASH BUOOET HERE (If any) CHANGE YOUR RATE HERE If diflorent lotal interest expense for both amounts MEMO: note rounding formula in the column G formula Amountsforthequarter:SalesbudgetBudgetedcashcollectionsBudgetedpurchasesBudgetedcashpayments-purchasesEndingCashBalanceIncStmtInterestExpenseIncStmtNetincomeBalSheetARBalSheetInventoryBalSheetAPBalSheetRetainedEarnings(RE)BalSheetTotalAssets(=Liab+OE)$17,715,600$13,449,500$11,262,240$10,760,200$599,219$7,181$5,112,319$7,115,100$2,708,640$1,580,040$8,657,719Scenario2$10,653,759 "MEMO; interest expense calculabion: MEMO: interest expense on amount borrowed in 2 nd month: To help you caloulate interest and round the amount total amount borrowed in 2 nd month to the nearest dolac, formulas are provided in the yellow cells. rate per year intecest for 12 months 5 number of months in a year interest for 1 month 5 months outstanding total interest expense for this amount ENIER AMOUNIS FROM CASH BUDGET HERE (II any) CHANGE YOUR RATE HERE Y diPnRent Interest expense on amount borrowed in 1st month: total amount borrowed in 1 st month rate per year interest for 12 months 5 number of months in a year interest for 1 month 5 months outstanding total interest expense for this amount ENTER AMOUNTS FROM CASH BUOOET HERE (If any) CHANGE YOUR RATE HERE If diflorent lotal interest expense for both amounts MEMO: note rounding formula in the column G formula