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
The company has an agreement with a bank that allows the company to borrow the exact amount needed at the beginning of each month. The interest rate on these loans is 1% per month and for simplicity we will assume that interest is not compounded. At the end of the quarter, the company will pay the bank all of the accrued interest on the loan and as much of the loan as possible while still retaining at least $50,000 in cash.
For option with refinance, I completed similar calculations as in options 1 and 2. However, for the first 5 years the payment was as in option 1. Then, I calculated new payment for years 11-15 by using ending balance after 60 months as new loan amount; I used APR of 4.25% compounded monthly. Then, I found present values of tax savings. In this case, present time is after 60 month in house. When
Total Sales Dollars (for covering each incremental dollar of advertising) = $200,000 / $150,000 = $1.33
The case study selected for week three centers on a liability and assumption of risk case study. In this case study, Brent Thomas and George Banks are facing liability charges after Ricky Watts sustained a serious injury during hockey practice (Essex, 2016). In this situation, Thomas is the school principal, and Banks is the hockey coach as well as the gym teacher (Essex, 2016). Ricky obtained injuries after improperly blocking the puck (Essex, 2016). This case study was selected because it highlights a situation that will likely be faced by all future school leaders. Sports are popular among students, and there is inherent risk in each sporting event. A school is open to liability if they do not ensure that proper protocols are met.
Scenario 2 shows the practice having moderate growth and there is no decrease in the associate fee. Even though the growth rate is 8% and not 17.5%, the company can still repay the loan because the CATO is positive throughout the years. Miller might not be able to repay the loan that fast, like scenario 1, but would be able to repay it in 10 years.
The revenue is $600,600*1.2= $720,720. The variable cost changes as sales increases and fixed cost stays the same, the gross profit is $175,500. After tax, the net income is $100,557.
Profit: $686,670 ($225*$5,000= $1,125,000 (Revenue); $75*4,000=$300,000 + $50,000/4,000= $87.50 (Unit Cost); $87.50*4,000= $350,000 + $83,330= $433,330
a. How much would the payment be if rate of interest is 5% and you only financed the truck for 48 months?
8. Times interest earned = (Net Income + Interest) in Statement of Operations / Interest in
Compute the amount of gross profit to be recognized from the installment sale in 2006, 2007, 2008, 2009, and 2010 using point of delivery revenue recognition. Ignore interest charges.
Current funds allocated to advertising and sales promotion is 3% of net sales ($80,000,000) = $360,000
The fixed cost is assumed that Larry has discovered the other fixed cost incurred. The total investment is $800,000. The worst case scenario assumes that Larry got a total line of credit from the bank in the amount of $400,000 and invested $400,000 from other source. The Notes payable – short term and the long-term debt is (11.8 + 3.7) = 15.5 % from Table F in the handout. The Loan interest and payment per year is ($400,000 * 0.155)= $62,000. The Income data from Table F indicates that there is a 0.4% of all other expenses net out of the total sales which equals to $109,908 (5,700,666 gallons * $4.82 *0.4%) .
For payment of second year’s borrowed loan, this amount is payable through years 2 to 6.
iii. The cash amount to be paid for these leases in 2004 will be $44.
Normally your repayments will be payable on the first business day of each month and will be: