1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Please help with my excel h.w.

Discussion in 'Business Applications' started by annynickname, Nov 1, 2007.

Thread Status:
Not open for further replies.
Advertisement
  1. annynickname

    annynickname Thread Starter

    Joined:
    Nov 1, 2007
    Messages:
    1
    Hello, how are you.

    could you please help me to solve my business homework which is about excel.

    if you have excel here it is the link http://www.accd.edu/sac/business/tfriday/bcis1305/Mod4-Excel.html and please click where it says "special ll"

    if you don't have excel, these are the problems.

    A standard auto loan. For each of the 48 monthly payments compute the items in the table: Beginning Balance, Payment,
    Interest portion of the Payment, etc ... Use Excel's Payment function (PMT), and be careful about relative and absolute
    cell references. The payment, of course, will be the same for all months.

    A detail: interest rates are usually quoted on an annual basis. But here the payments are monthly. How will you account for
    this when you reference the interest rate?

    If you do this cleverly, you can specify the first two rows, then make one big copy for the other 46 rows.


    Amount $25,000.00

    Interest Rate 6%

    Months 48


    Beginning Balance Payment Amount Interest Principal Reduction Ending Balance
    1 25,000.00
    2
    3

    etc

    Total Interest Total Principal
    ================================================== ==========






    Prepare a Purchases Budget for Grunk that reflects a Cost of Merchandise Sold (Cost of Goods Sold, Cost of Sales)
    of 60% and a required ending inventory of 65% of the next months sales.

    Beginning inventory is $50,000.
    Sales for January of next year are estimated to be $365,000


    Jan Feb

    Sales $300,000

    Cost of
    Mrch Sold

    Ending
    Inventory

    Beginning
    Inventory 50,000

    Required
    Purchases
    ---------------------------------------------------------------------



    Prepare a Cash Receipts Budget for Grunk based on its historical cash collection patterns:

    50% in the month of sale.
    40% in the month following the sale.
    10% two months following.

    January collections will include $80,000 from the previous December and $20,000 from November.
    February collections will include $20,000 from the previous December.

    Jan Feb

    Sales $300,000

    Cash Collections:

    Month of
    Sale

    Month $80,000
    Following

    2 Months $20,000 20,000
    Following

    Total
    ================================================== ==========



    Create a Cash Disbursements Budget for Grunk based on historical patterns:

    40% of payments are made in the month of purchase.
    60% of payments are made in the month following.

    January payments are expected to include $60,000 from December purchasing activity.


    Jan Feb

    Required
    Purchases

    Cash Payments:

    Month of
    Purch

    Month 60,000
    Following

    Total
    Payments
    =========================================


    thank you.
     
  2. slurpee55

    slurpee55

    Joined:
    Oct 20, 2004
    Messages:
    7,837
    Don't usually do classwork for people, and this is extra work, it appears. If you look at your syllabus, one section says
    "E. Academic Dishonesty: Students may be subject to disciplinary proceedings resulting in an academic penalty or disciplinary penalty for academic dishonesty. Academic Dishonesty includes, but is not limited to, cheating on a test, plagiarism and collusion. For additional information refer to the “Student Code of Conduct” in the San Antonio College Bulletin."
    Pretty sure that covers this.
     
  3. The Villan

    The Villan

    Joined:
    Feb 20, 2006
    Messages:
    2,255
    However, I would assume that there is no harm helping to explain any part of the question that the poster doesn't understand.
    So Annynickname, do you have a specific question related to the exerecise that you don't understand?
    As slurpee says, we do not do homework for students.
     
  4. Zack Barresse

    Zack Barresse

    Joined:
    Jul 25, 2004
    Messages:
    5,452
    I agee with both slurpee and Villan here. So here's my contribution to homework:

    Read the Help files. (RTFM)
     
  5. The Villan

    The Villan

    Joined:
    Feb 20, 2006
    Messages:
    2,255
    Whats the F for then firefytr LOL :)
     
  6. jimr381

    jimr381

    Joined:
    Jul 20, 2007
    Messages:
    4,189
    First Name:
    Jim
    Fancy ;)
     
  7. slurpee55

    slurpee55

    Joined:
    Oct 20, 2004
    Messages:
    7,837
    Free? Flammable? :)
     
  8. Zack Barresse

    Zack Barresse

    Joined:
    Jul 25, 2004
    Messages:
    5,452
    Ahem.. this is a *public* forum gentlemen.. ;)
     
  9. The Villan

    The Villan

    Joined:
    Feb 20, 2006
    Messages:
    2,255
    Read The Fancy Manual doesn't sound right to me :)
     
  10. jimr381

    jimr381

    Joined:
    Jul 20, 2007
    Messages:
    4,189
    First Name:
    Jim
    I was just trying to tame it a little hehe
     
  11. Zack Barresse

    Zack Barresse

    Joined:
    Jul 25, 2004
    Messages:
    5,452
    And I appreciate it! :D
     
  12. slurpee55

    slurpee55

    Joined:
    Oct 20, 2004
    Messages:
    7,837
    I haven't had a fancy manual in years!
     
  13. The Villan

    The Villan

    Joined:
    Feb 20, 2006
    Messages:
    2,255
    Slurpee
    I hope you are female.
    >>I haven't had a fancy Manuel in years! <<

    LOL :)
     
  14. Zack Barresse

    Zack Barresse

    Joined:
    Jul 25, 2004
    Messages:
    5,452
    I'm thinking these might possibly be options...

    Read The Funny Manual
    Read The Frustrating Manual
    Read The Friendly Manual
    Read The Futuristic Manual
    Read The Fung Shui Manual
    Read The Fabled Manual

    Okay, so I was bored. ;)
     
  15. slurpee55

    slurpee55

    Joined:
    Oct 20, 2004
    Messages:
    7,837
    I have had a friable manual or two...and a few I wanted to fry!
    And nope, Villian, male here, and I never considered a Manuel! But if you are thinking that way, what's the R for?

    And "Read The Friendly Manual" ????
    LOL - no such thing!!!!!!!!!!!!!!!!
     
  16. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/646646

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice