preview

Case Study On Current And Pass Liability Balance

Decent Essays

Data given The change is calculated by subtracting present year liabilities to prior year liabilities Year Currents and pass Liability Balance Deposits 1 75 75 2 225 150 3 325 100 4 395 70 5 435 40 6 455 20 Since nothing shows in the exhibits and the case that they will be a change in year 7. I am assuming that the next year (7) deposits will be $10 as from year 5 to year 6 is half of the deposits, I am choosing half from year 6 to year 7, which is ($20M/2=$10M). Year 7 ($455+10=$465) - Revenue from Loan and interest Data given for outstanding loans I am assuming that the loans are repaid at the end of June 30th during year 7 since most of the term of the loan of payment are semi-annual repayment Different loans Numbers The …show more content…

So, estimate no tax will be paid in year 7. Total interest paid by the end of the year is: $12.2M+$0.55M+$50.05M-12.65M = $50.15 million Prior year accrued interest: $3.6,3.5,4, 3.2 Year 7 interest: $3.91, $3.72. The total revenue expected in year 7 will be: $(3.6+3.5+4+3.2+3.91+3.72) = $21.93 million The interest payment to the depositors for prior year cash expenses estimated $50.15 and $2.3. $21.93 - $(50.2+2.33) = $30.6 million Cash available for new year estimates Cash receipts: New deposits in Y7 $10+ Loan from customers $116.93= $126.93 Cash Disburse: Interest pay ($50.2) + salaries, wages and income taxes ($2.33) = $52.53 Total cash available: cash increase ($74.4+$81.00) = $155.50 I am assuming the company will have a minimum balance of $35.00 with a new loan of $140. Loan Number Amount Interest % revenue from the interest 405 $28.60 15% $4.29 406 36 10% $3.60 601 76.9 13% $10.00 602 52.1 15% $3.91 Semi-annual outstanding 603 57.2 13% $3.72 Semi-annual outstanding 604 96.9 10% $9.69 605 45.6 14% $6.38 New loan 140 13% $9.10 Semi-annual outstanding Total $50.69 With 8% of interest fees, the revenue on the new loan will be %140*8% = $11.20 estimate. Estimate of $0.55 for interest deposits above and

Get Access