Ask Experts Questions for FREE Help !
Ask
    needygirl's Avatar
    needygirl Posts: 11, Reputation: 1
    New Member
     
    #1

    Jun 12, 2012, 01:37 PM
    Accounting problem - stuck!
    The monthly cash budgets for the first quarter of 2009 are shown below ($000 omitted) for XYZ Company. A minimum cash balance of $40,000 is required. A line of credit has been established with ABC's bank at a 7.5% interest rate. Calculate the missing amounts:

    http://ezto.mhhm.mcgraw-hill.com/132...a=image025.png

    The link above provides the chart with the blanks that I am suppose to fill in.
    Here is what I have so far:

    January blanks:
    136
    100
    228

    February blanks:
    -40
    174
    78

    March
    272
    48
    4

    Q1 Total
    622
    316
    186

    I am not sure that I truly understand the borrowings and repayments that they are looking for on the chart. I hope you are able to see it! Please help.
    paraclete's Avatar
    paraclete Posts: 2,706, Reputation: 173
    Ultra Member
     
    #2

    Jun 12, 2012, 03:42 PM
    Quote Originally Posted by needygirl View Post
    The monthly cash budgets for the first quarter of 2009 are shown below ($000 omitted) for XYZ Company. A minimum cash balance of $40,000 is required. A line of credit has been established with ABC's bank at a 7.5% interest rate. Calculate the missing amounts:

    http://ezto.mhhm.mcgraw-hill.com/132...a=image025.png

    The link above provides the chart with the blanks that I am suppose to fill in.
    Here is what I have so far:

    January blanks:
    136
    100
    228

    February blanks:
    -40
    174
    78

    March
    272
    48
    4

    Q1 Total
    622
    316
    186

    I am not sure that I truly understand the borrowings and repayments that they are looking for on the chart. I hope you are able to see it! Please help.
    In the first month the borrowings would be 80 restoring the balance to 40 which becomes to opening balance for the following month, etc
    needygirl's Avatar
    needygirl Posts: 11, Reputation: 1
    New Member
     
    #3

    Jun 12, 2012, 04:03 PM
    Quote Originally Posted by paraclete View Post
    in the first month the borrowings would be 80 restoring the balance to 40 which becomes to opening balance for the following month, etc
    BUT there is 7.5% interest. That interest is then paid and you have to have a minimum of 40,000 in the account..?
    paraclete's Avatar
    paraclete Posts: 2,706, Reputation: 173
    Ultra Member
     
    #4

    Jun 12, 2012, 05:08 PM
    Quote Originally Posted by needygirl View Post
    BUT there is 7.5% interest. That interest is then paid and you have to have a minimum of 40,000 in the account. . . ?!
    In my experience interest is determined and paid in arrears so if you borrow 80 and repay it in a subsequent month you repay 81. If you want to be more precise you will have to expand to whole numbers instead of thousands. I have said this to others, there is such a thing as overthinking a problem assume the simplist explanation unless you are told otherwise
    Perhaps these numbers will mean something to you without captions they are meaningless but you already have a table into which they fit, press the reply button to restore the format
    52 40 40 52
    136 214 272 622
    188 254 312 674
    100 120 86 306
    60 88 48 196
    68 16 4 88
    18 18
    228 214 166 608
    -40 40 146 66
    80 -81 -1
    40 40 65 65
    It is a shame this site doesn't allow you to maintain formatting of a table

Not your question? Ask your question View similar questions

 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Having problem with physics coursework regarding magnetic flux density, I'm stuck [ 0 Answers ]

For my physics coursework, I've been measuring magnetic flux density of different solenoids. The solenoids are coils of wire wrapped around a hollow plastic cuboid (e.g. 5cm x 5cm x 30cm). I then stick a probe down the hollow centre which measures the magnetic flux density. Im unsure about my...

I was doing one Euler project problem, but stuck... [ 15 Answers ]

Okay, as the title says, I'm stuck. I got a program and from what I know, it is supposed to work, but fact is... it doesn't. I don't know what might be wrong it it, for is seems good to me. The question is to find the largest palindrome number (one which can be read in either directions, e.g.....

Can some one help I got stuck on my accounting hw [ 2 Answers ]

I thought I was doing pretty well until I got to the supplies part I'm not sure if the template is wrong but there are 3 supply entries in the journal (oct. 1 desbit 1500, oct 5 debit2500 and oct. 18 debit 600) but the ledger for supplies template( is requesting post for the 1st, 18th and the 31st)...

Accounting and stuck! [ 6 Answers ]

Hello, Indicate which of the following current assests and current liabilities are operating accounts and thus included in the adjustment of net income to cash flow from operating activities and what is considered cash, investing, or financing accounts? Accounts payable Accounts receivable...


View more questions Search