Ask Experts Questions for FREE Help !
Ask

Susquehanna equipment rentals

Asked Mar 11, 2008, 10:41 AM — 12 Answers
Anyone have the susquehanna equipment rentals spreadsheets complete?

12 Answers
claudy's Avatar
claudy Posts: 1, Reputation: 1
New Member
 
#2

Sep 18, 2008, 07:03 PM
I am trying, did you finish?
Helpful
yh70's Avatar
yh70 Posts: 6, Reputation: 5
New Member
 
#3

Oct 13, 2008, 03:56 AM
Hello

Check this, I think you'll find the spreadsheet that you need

Highered.mcgraw-hill.com/sites/dl/free/0072996501/388052/CompProblem01.pdf


Good luck
Helpful
dietpepsimax's Avatar
dietpepsimax Posts: 3, Reputation: 1
New Member
 
#4

Oct 25, 2008, 10:47 AM
I am trying to finish this problem, has anyone out there finished it yet? I just want to make sure I am doing this correctly.
Helpful
yh70's Avatar
yh70 Posts: 6, Reputation: 5
New Member
 
#5

Oct 27, 2008, 03:39 PM
Hello

You can write your answer here and i'll check it for you whether if you are in the right track or not.

Just write the part that you need.
Helpful
dietpepsimax's Avatar
dietpepsimax Posts: 3, Reputation: 1
New Member
 
#6

Oct 27, 2008, 04:33 PM
Susquehanna equipment rentals
Worksheet
December 31, 2007

C.post december transactions and adjusting entries to ledger accounts
Assets liabilities owners equity
Cash-$200,000
-$140,000 purchase equip.
-$12,000 shapiro realty
+$8,000 mcnamer const.
-$5,200 salaries 1st part
+$12,000 equip rent earn
-$600 parts expense ap
+$2,000 collect ar
-$5,200 salaries 2nd part
-$2,000 dividends payable
-$9,600 insurance policy
-$4,400 collect ar
+$15,600 equip. Rent earn
-$1,400 salaries payable

Cash at dec. 31= 65,000

notes payable-$100,000 captial stock-20,000
Accounts recievable- $12,800 accounts payable-$1,000 dividends-2,000
Pre-paid rent-$12,000 accumulated depreciation rental equip.-$30,000 retained earnings
$140,800
Un-expired insurance-$9600 interest payable-$6,000 income summary
Gross income $238,000
Dividends paid $2,000
Income taxes paid $95,200
Net income at year end-$140,800
Office supplies-$1000 salaries payable-$5,200
-$5,200
-1,400
Salary expense - $11,800
Rental equipment-$240,000 dividends payable-$20,000
Unearned rental fees-$8,000 income taxes payable-$95,040
Rent fees earned-$38,000
Maintenance expense
utilitites expense-$700
rent expense-$12,000
office supplies expense-$1,000
depreciation expense-$30,000
interest expense-$6,000
income taxes expense-$95,200
(cash flow in =238,000 x 4%=95,200)
Helpful
dietpepsimax's Avatar
dietpepsimax Posts: 3, Reputation: 1
New Member
 
#7

Oct 27, 2008, 04:33 PM
Susquehanna equipment rentals
Worksheet
December 31, 2007

C.post december transactions and adjusting entries to ledger accounts
Assets liabilities owners equity
Cash-$200,000
-$140,000 purchase equip.
-$12,000 shapiro realty
+$8,000 mcnamer const.
-$5,200 salaries 1st part
+$12,000 equip rent earn
-$600 parts expense ap
+$2,000 collect ar
-$5,200 salaries 2nd part
-$2,000 dividends payable
-$9,600 insurance policy
-$4,400 collect ar
+$15,600 equip. Rent earn
-$1,400 salaries payable

Cash at dec. 31= 65,000

notes payable-$100,000 captial stock-20,000
Accounts recievable- $12,800 accounts payable-$1,000 dividends-2,000
Pre-paid rent-$12,000 accumulated depreciation rental equip.-$30,000 retained earnings
$140,800
Un-expired insurance-$9600 interest payable-$6,000 income summary
Gross income $238,000
Dividends paid $2,000
Income taxes paid $95,200
Net income at year end-$140,800
Office supplies-$1000 salaries payable-$5,200
-$5,200
-1,400
Salary expense - $11,800
Rental equipment-$240,000 dividends payable-$20,000
Unearned rental fees-$8,000 income taxes payable-$95,040
Rent fees earned-$38,000
Maintenance expense
utilitites expense-$700
rent expense-$12,000
office supplies expense-$1,000
depreciation expense-$30,000
interest expense-$6,000
income taxes expense-$95,200
(cash flow in =238,000 x 4%=95,200)





I have no clue if these figures are right. I am probably way off base.
Helpful
yh70's Avatar
yh70 Posts: 6, Reputation: 5
New Member
 
#8

Oct 28, 2008, 05:18 AM
C.LEDGER ACCOUNTS


Cash
1/12 200,000 140,000 1/12
8/12 8,000 12,000 1/12
15/12 12,000 5,200 12/12
23/12 2,000 5,200 26/12
31/12 15,600 600 27/12
9,600 29/12
237,600 172,600
Balance 65,000

--------------------------------------------------


Capital Stock
200,000 1/12



Balance 200,000

--------------------------------------------------

Salaried Expense
12/12 5,200
26/12 5,200
26/12 1,400


Balance 11,800

---------------------------------------------------

Accounts Receivable
15/12 6,000 2,000 23/12
31/12 1,500
31/12 4,400



Balance 9,900

---------------------------------------------------

Rental Equipment
1/12 240,000



Balance 240,000

---------------------------------------------------

Notes Payable
100,000 1/12





Balance 100,000

---------------------------------------------------

Rental Fees Earned
18,000 15/12
20,000 31/12
3,700 8/12
1,500 31/12


Balance 43,200

---------------------------------------------------

Maintenance Expense
17/12 600


Balance 600

---------------------------------------------------

Prepaid Rent
1/12 12,000 4,000


Balance 8,000

---------------------------------------------------

Office Supplies
4/12 1,000 400 31/12


Balance 600

---------------------------------------------------

Dividends
28/12 2,000


Balance 2,000

--------------------------------------------------

Dividend Payable
2,000 28/12


Balance 2,000

--------------------------------------------------

Unearned Rental Fees
8/12 3,700 8,000 8/12


Balance 4,300
--------------------------------------------------

Accounts Payable
600 1,000 4/12
600 17/12
700 31/12

Balance 1,700

--------------------------------------------------

Unexpired Insurance
29/12 9,600


Balance 9,600

--------------------------------------------------

Utility Expense
31/12 700


Balance 700

--------------------------------------------------
Rent Expense
1/12 4,000


Balance 4,000
--------------------------------------------------

Interest Expense
1/12 500


Balance 500
--------------------------------------------------
Interest Payable
500 1/12


Balance 500
--------------------------------------------------

Depreciation Expense
1/12 2,500


Balance 2,500

--------------------------------------------------
Accumulated Depreciation
1/12 2,500


Balance 2,500
--------------------------------------------------

Supplies Expense
31/12 400


Balance 400

--------------------------------------------------
Salaried Payable
26/12 1,400


Balance 1,400
--------------------------------------------------
Income Tax Expense
31/12 9,080


Balance 9,080

--------------------------------------------------
Income Tax Payable
9,080 31/12

Balance 9,080

--------------------------------------------------

THATS WHAT I THINK ITS CORRECT. YOU HAVE TO CHECK YOUR JOURNALS AND STATEMENTS.

LET ME KNOW YOUR BALANCE WHEN YOU FINISH.

GOOD LUCK
Helpful
twist3ci's Avatar
twist3ci Posts: 1, Reputation: 1
New Member
 
#9

Nov 30, 2008, 11:43 AM
Anyone got the answer to the whole problem?
Helpful
ByondWords's Avatar
ByondWords Posts: 1, Reputation: 1
New Member
 
#10

Nov 30, 2008, 02:37 PM
Okay all the ledgers listed above do not balance.

If your going to be nice enough to post numbers up please be nice enough to check your work. None of the numbers balance and are throwing everything off.

If somebody has the correct anwsers for this whole problem please post them up.
Helpful

Not your question? Ask your question View similar questions

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search

Add your answer here.

Remove Text Formatting

Undo
Redo
 
Decrease Size
Increase Size
Bold
Italic
Underline
Align Left
Align Center
Align Right
Ordered List
Unordered List
Decrease Indent
Increase Indent
Insert Email Link
Wrap [QUOTE] tags around selected text
Wrap [CODE] tags around selected text
Wrap [HTML] tags around selected text
Wrap [PHP] tags around selected text
Wrap [YOUTUBE] tags around selected text
Notification Type:



Check out some similar questions!

Landlord foreclosure on rentals [ 1 Answers ]

Do we have any legal action against our landlord that allowed the house that we live in to go into foreclosure? He has been collecting our rent checks and not paying the mortgage for over a year. He also has multiple other properties and lives in a $2 mil mansion. I had asked him multiple times if...

Rentals in New Jersey [ 2 Answers ]

I am from INDIA. I would be travelling to Trenton, New Jersey and reaching there on 16th December, 2007. Could anybody help me to know what kind of house would I need for my family ( Myself, Spouse and Kid (3 Yrs) ) ) and sites where I can found the house on rentals. What is average rental for 1...

Verbal with regard to possible rentals [ 1 Answers ]

We have been trying to sell our home for over 60 days. We have spoken to a person who is willing to rent it until she can try to afford to buy it. We told her it was no problem. However, we have had someone call who may be interested in buying the house outright. Do we have the right to...

Real estate law for short-term rentals [ 1 Answers ]

What law regulates short-term (vacation) rentals? I keep finding information about long-term contracts and rental agreements, but there is no information regarding the short-term (vacation) rental laws and regulations. Are they the same? Please help!

Law for keys to Rentals [ 1 Answers ]

Wondering if anyone knows what the California law(s) is for the landlord having keys to access the properties they own. Have a renter who has put a chain and lock on the front gate not allowing us onto property to check cooler for leak this morning after informing them would be there this AM. ANy...


View more Finance & Accounting questions Search