Preview

Raffiee Kid Assignment

Satisfactory Essays
Open Document
Open Document
551 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Raffiee Kid Assignment
Question1: Raffie’s Kids, a non-profit organization that provides aid to victims of domestic violence, low-income families, and special needs children has a 30-year, 5% mortgage on the existing building. The mortgage requires monthly payments of $3,000. Raffie’s bookkeeper is preparing financial statements for the board and in doing so, lists the mortgage balance of $287,000 under current liabilities because the board hopes to pay off the mortgage in full next year. $20,000 of the mortgage principal will be paid next year according to the mortgage agreement. * The board members call you, their trusted CPA. To advise them on how Raffie’s Kids should report the mortgage on the balance sheet. Provide the recommendation and discuss the reason for your recommendations.

Solution: Company has a mortgage loan payable and is required to make monthly payments of $3,000 per month. Each of the monthly payments includes a $2,850 principal payment plus approximately $1,50 of interest. This means that during the next 12 months, the company will be required to repay $34,200 ($2,850 x 12 months) of principal. The necessary principal payments due within one year of the balance sheet date must be reported as a current liability. The remaining principal of $252,800 ($287,000 minus $34,200) will be reported as a long-term liability, because it is not due within one year of the balance sheet date.
It can find the amount of principal due within the next year by reviewing the loan amortization schedule for each loan or by asking your lender. Payment Frequency | Payment Amount | Amortization | Term
Interest
Cost | Amortization
Interest
Cost | Amortization Interest Savings vs. Monthly Payment | Monthly | $1,531.70 | 30.0 yrs | $264,405.61 | $264,405.61 | $0.00 | Semi-monthly | $765.85 | 30.0 yrs | $263,106.20 | $263,106.20 | $1,304.06 | Bi-weekly | $706.94 | 29.8 yrs | $260,590.43 | $260,590.43 | $3,819.83 | Weekly | $353.47 | 29.8 yrs | $260,001.73 | $260,001.73

You May Also Find These Documents Helpful

  • Satisfactory Essays

    Management would like to maintain a minimum cash balance of $5,000 at the end of each month. The company has an agreement with a local bank that allows the company to borrow in increments of $1,000 at the beginning of each month, up to a total loan balance of $50,000. The interest rate on these loans is 1% per month, and for simplicity, we will assume that interest is not compounded. The company would, as far as it is able, repay the loan plus accumulated interest at the end of the quarter.…

    • 434 Words
    • 4 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Hrm/531 Final Exam Paper

    • 807 Words
    • 4 Pages

    (a) Compute the monthly payment using the PMT function in Excel and then prepare an amortization table. Fully amortize the loan by going out to the last payment.…

    • 807 Words
    • 4 Pages
    Satisfactory Essays
  • Satisfactory Essays

    10) There are no accountants on the board of the Oriole Corporation, a privately held corporation. The board routinely relies on a Certified Public Accountant (CPA) to explain the financial situation of the corporation. The board does not do an independent analysis of the CPAТs report. In these circumstances, the board i…

    • 707 Words
    • 4 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Acct301

    • 483 Words
    • 2 Pages

    EXERCISE 7-13 PINK MARTINI CORPORATION Cash Budget For the Quarter Ended March 31, 2012 Beginning cash balance $31,000 Add: Receipts Collections from customers 180,000 Sale of equipment 3,500 Total receipts $183,500 Total available cash $214,500 Less: Disbursements Direct materials 41,000 Direct labor 70,000 Manufacturing overhead 35,000 Selling and administrative expense 45,000 Purchase of securities 12,000 Total disbursements $203,000 Excess of available cash over disbursements 11,500 Financing Borrowings 13,500 Repayments Ending cash balance $25,000 PROBLEM 7-1A DANNER FARM SUPPLY COMPANY Sales Budget 6 Months Ending June 30, 2012 Quarter Six Months 1 2 Expected unit sales 28,000 42,000 70,000 Unit selling price 60 60 60 Total sales $1,680,000 $2,520,000 $4,200,000 DANNER FARM SUPPLY COMPANY Production Budget 6 Months Ending June 30, 2012 Quarter Six Months 1 2 Expected unit sales 28,000 42,000 Add: Desired ending finished goods 12000 18000 Total required units 40,000 60,000 Less: Beginning finished goods units 8,000 12,000 Required production units 32,000 48,000 80,000 DANNER FARM SUPPLY COMPANY Direct Materials Budget—Gumm 6 Months Ending June 30, 2012 Quarter Six Months 1 2 Units to be produced 32,000 48,000 Direct materials per unit 4 4 Total pounds needed for production 128000 192000…

    • 483 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    Business Math Unit 5

    • 704 Words
    • 3 Pages

    Joe’s total monthly payment to the bank will consist of the mortgage interest plus principal amount plus monthly payments for insurance and taxes. What will the total monthly payments be for a 15-year and a 30-year loan including taxes and insurance?…

    • 704 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    Assignment 1 TAXX301

    • 1149 Words
    • 7 Pages

    Instalments are required because 2012 owing is more than 3000 and 2011 owing are also more than 3000. Instalments are due on March 15, June 15, September 15, and December 15.…

    • 1149 Words
    • 7 Pages
    Satisfactory Essays
  • Good Essays

    Law 531 Final Exam

    • 1213 Words
    • 6 Pages

    10) There are no accountants on the board of the Oriole Corporation, a privately held corporation. The board routinely relies on a Certified Public Accountant (CPA) to explain the financial situation of the corporation. The board does not do an independent analysis of the CPA’s report. In these circumstances, the board is…

    • 1213 Words
    • 6 Pages
    Good Essays
  • Satisfactory Essays

    Exam Paper Afin253

    • 3460 Words
    • 14 Pages

    Question 2: You want to buy an apartment worth $500,000. You have saved a deposit of $50,000. The bank has agreed to lend you the $450,000 as a fully amortising mortgage with a term of 25 years. The interest rate is 6% pa and is not expected to change. What will be your monthly payments? (a) 1,500.00 (b) 2,250.00 (c) 2,855.79 (d) 2,899.36 (e) 35,202.02…

    • 3460 Words
    • 14 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Mathl 104 Research Paper

    • 428 Words
    • 2 Pages

    Technology is pervading all levels of mathematics teaching and learning in our modern world, bringing ever more sharply into focus the change from traditional pencil and paper learning to a mixture of calculator, computer and pencil and paper learning environments. Currently the loan has 25 years remaining. Therefore to find out the P&I payment, you would plug in 300 for N (25x12), 5.75% for I, 0 for FV, and $112,242.47 for PV, and then press PMT which gives you the $706.12. However, we want to find out how much more money they have to pay to pay off the loan in 20 years instead of 25. Therefore change N to 240 (20x12) instead of 300. Then press PMT and we should get $788.04. Next, subtract the P&I payment they are making now (706.12) from $788.04, which tells you they need to pay $81.92 extra towards the principal each month to have the loan paid off in 20 years instead of 25.…

    • 428 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Financial Project

    • 909 Words
    • 3 Pages

    The first being how much it would be extra monthly in order to pay off the loan in 20 years instead. Knowing that my total payment on the home is $917.25 which includes escrow of $211.13, I would try to reamortize the loan based on a higher monthly payment. I know that I have $100.00 after bills and expenses left over. One of the easiest ways to determine if this would be enough would be to take the monthly principal and interest and add $100.00 to it which would give me a new monthly payment of $806.12 towards principal and interest at the 5.75% rate on the remaining balance of $121,000. So using the above amortization table for monthly cost per $1000 I can determine that the amount of loan remaining divided into 1000 multiplied by the entry for 20 years at 5.75% or 7.0208 is the new payment needed to pay off the loan within 20 years. This comes to the product of 121 and 7.0208 or 849.52 which is more than the amount that I have available to budget. This would determine with the current expenses I would be unable to pay the amount needed to satisfy the mortgage within 20 years unless I either receive an increase in pay or get rid of an unnecessary monthly expense. At this point, I would need to prioritize the expenses and determine if my goal for the home is more important than an expense totaling 42.40 or more to meet my new goal.…

    • 909 Words
    • 3 Pages
    Satisfactory Essays
  • Satisfactory Essays

    5) Derrick and Sandra own their home and they have a 30 year mortgage loan on their home. In 2008, they paid $8,500 in mortgage interest and $1,900 in property taxes. They also contributed a total of $2,000 in cash to Section…

    • 486 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    Pro Forma Case Study

    • 699 Words
    • 3 Pages

    Long Term Debt is $110,000 at 2007 year end. Back in 2003, Jones bought out Verden from the company for $250, 000. Under their agreement, Jones would pay Verden the $250,000 in installments of $2,000 per month plus interest of 8% per year. In year 2006, the loan outstanding was $134,000 so in 2007 he should pay another installment of $24,000 making the year end balance $110,000. Therefore, current long term debt is $24,000.…

    • 699 Words
    • 3 Pages
    Good Essays
  • Better Essays

    Acc 403 Assignment 1

    • 855 Words
    • 4 Pages

    1- Analyze the audit report that the CPA firm issued. Ascertain the legal liability to third parties who relied on financial statements under both common and federal securities laws. Justify your response.…

    • 855 Words
    • 4 Pages
    Better Essays
  • Good Essays

    Question: There are no accountants on the board of the Oriole Corporation, a privately held corporation. The board routinely relies on a Certified Public Accountant (CPA) to explain the financial situation of the corporation. The board does not do an independent analysis of the CPA¿s report. In these circumstances, the board is…

    • 1002 Words
    • 5 Pages
    Good Essays
  • Satisfactory Essays

    EXERCISE 14-1 (15-20 minutes) Valuation account relating to the long-term liability, bonds payable (sometimes referred to as an adjunct account). The 3,000 would continue to be reported as long-term. Current liability if current assets are used to satisfy the debt. Current liability, 200,000 long-term liability, 800,000. Current liability. Probably noncurrent, although if operating cycle is greater than one year and current assets are used, this item would be classified as current. Current liability. Current liability unless (a) a fund for liquidation has been accumulated which is not classified as a current asset or (b) arrangements have been made for refinancing. Current liability. Current liability. EXERCISE 14-2 (15-20 minutes) Discount on Bonds PayableContra account to bonds payable on balance sheet. Interest expense (credit balance)Reclassify to interest payable on balance sheet. Unamortized Bond Issue CostsClassified as Other Assets on balance sheet. Gain on repurchase of debtClassify as part of other gains and losses on the income statement. Mortgage payableClassify one-third as current liability and the remainder as long-term liability on balance sheet. Debenture bondsClassify as long-term liability on balance sheet. Notes payableClassify as long-term liability on balance sheet. Premium on bonds payableClassify as adjunct account to Bonds Payable on balance sheet. Treasury bondsClassify as contra account to bonds payable on balance sheet. Income bonds payableClassify as long-term liability on balance sheet. EXERCISE 14-3 (15-20 minutes) 1.Paul Simon Company(a)1/1/04Cash…

    • 7235 Words
    • 2 Pages
    Satisfactory Essays