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

Not open for further replies.

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

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

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 &#8220;Student Code of Conduct&#8221; in the San Antonio College Bulletin."
Pretty sure that covers this.

3. ### 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

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

5. ### The Villan

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

Joined:
Jul 20, 2007
Messages:
4,189
First Name:
Jim
Fancy

7. ### slurpee55

Joined:
Oct 20, 2004
Messages:
7,837
Free? Flammable?

8. ### Zack Barresse

Joined:
Jul 25, 2004
Messages:
5,452
Ahem.. this is a *public* forum gentlemen..

9. ### The Villan

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

10. ### jimr381

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

11. ### Zack Barresse

Joined:
Jul 25, 2004
Messages:
5,452
And I appreciate it!

12. ### slurpee55

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

13. ### 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

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

Okay, so I was bored.

15. ### 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!!!!!!!!!!!!!!!!

As Seen On