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