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

    Nov 29, 2009, 06:37 PM
    financial statement
    The problem is a little long, but I'd appreciate any feedback. Basically, I just want to know if I'm on the right track. My figures are at the end and are not complete yet.

    Part 1:

    Part 2:

    Part 3:

    Part 4:

    This is what I have so far:

    Income Statement:

    Service Revenue = 7851901 (First 3 trips, not including Trip 4's unearned service revenue)

    Expenses:
    Cost of Tour 8,336,198
    Rent 42,000
    Salary 1,584,000
    Furniture and Equipment 82,125
    Depreciation 26,083
    Office Expenses 120,000
    Installation 16,000
    Advertising 185,107
    Promotional 94,018
    Interest 40,000
    Income Tax 3,062,241

    Net Income: About -5,200,000


    (Incomplete) Statement of Cash Flows:

    Operating:
    Net Loss -5,200,000
    Depreciation 26,000
    Increase in Unearned Service Revenue 2,877,265

    Investing:
    Acquisition of plant assets (44,200)

    Financing:
    Long-Term Debt 1,225,200
    Common Stock 200,000


    (Incomplete) Balance Sheet:

    Assets:

    Cash?? (A little confused as to how I find this.)
    Furniture, Fixtures, Equipment

    Liabilities:

    Unearned Service Revenue 2,877,265 (From Trip 4 which leaves Dec. 31, and ends about a week later)
    Income Tax Payable 3,062,241
    Lease Payments (?) 24,000
    Long-Term Debt 1,225,200
    Accrued Interest 42,520
    morgaine300's Avatar
    morgaine300 Posts: 6,561, Reputation: 276
    Uber Member
     
    #2

    Nov 30, 2009, 02:57 AM

    Could you attach those or shrink them or put them up somewhere and link to them or something. That's twice the width of my monitor and about darn near impossible to follow back and forth like that. I'd be happy to look at it if I could read it.
    morgaine300's Avatar
    morgaine300 Posts: 6,561, Reputation: 276
    Uber Member
     
    #3

    Nov 30, 2009, 02:58 AM
    You also might want to hit Enter manually to create line breaks,
    Cause that big wide thing is now causing everything to be wide with it.
    KRH31's Avatar
    KRH31 Posts: 4, Reputation: 1
    New Member
     
    #4

    Nov 30, 2009, 09:49 AM
    Thanks for telling me about the size because I had no idea there was a problem with it. I've retyped the problem below.

    Requirement: Prepare a balance sheet, income statement, and statement of cash flow as of 12/31/08.

    The company takes people on tours around the world. When people sign up for a trip, they pay a deposit. The final payment is expected before the trips starts, but sometimes the company doesn't get paid until after the trip. The company has to make a deposit for hotels, airfare, etc. before the trip starts. Cost of tour expenses should be paid before the start of the trip, but there are always last minute changes, so the company always has a few checks to write after the trip ends.

    On 1/1/08, the two owners of the company each took out an equity loan from their home for $200,000 and contributed it to the company in return for common stock. They also got a loan from a relative for $1,000,000 at 4% interest. They were told to pay the interest whenever they have the cash. The company did not make any interest payments during the year. The note is due in 5 years.

    On 1/11/08, they found an office space and signed a 3 year lease. January through May, rent will be free. Then rent will be $6,000 per month for the next year, then $7,000 per month for the remainder of the lease term. Rent is due at the beginning of each month. All rent payments were made on time.

    The company plans to have 15 employees including the two owners. On 1/11/08, they purchased 15 desks and chairs for $275 each plus 8.25% sales tax plus $100 for shipping for all the 15 desks and chairs. The furniture was received in the new office on 1/20/08. One of the owners paid for the desks and chairs in full with a company check.

    Also on 1/11/08, they ordered 15 computer workstations and printers. They would have cost $2,100 each including tax and shipping, however, they decided to take out a loan which financed 80% of it at 10% amortized over 3 years.

    On 1/12/08, a wiring contractor came to the office and installed wiring for the computer and the phones at a cost of $6,000. One of the owners paid the contractor in full on 1/12/08.

    On 1/13/08, the company ordered business software amounting to $1,500 per computer. They also purchased a server for $5,000 plus sales tax.

    On 1/22/08, a computer consultant setup their computer system at a cost of $7,000.

    By 1/23/08, they had hired all their employees.

    On 1/24/08, one of the owners sent a company check for the software, server, and consulting time, in full.

    They will start work on 2/1/08, which will be considered the first day of business for the company.

    The company hired 2 salespeople with a monthly salary of $6,000 per month per person; 10 travel coordinators at $8,000 per month per person; and 1 administrative person at $4,000 per month. The two owners will each make $18,000 per month.

    Payroll is paid monthly on the first working day after each month. Payroll tax expense is 10% of salaries. Each employee gets 2 weeks of vacation per year. During 2008, no one took vacation. All employees inculding the two owners officially started working on 2/1/08. All payrolls were paid on time. The company also pays for the employee's health insurance which is $300 per month per employee. This is due and payable on the first day of every month. All health insurance payments were made on time.

    On 1/23/08, the company leased a copier which would normally cost $80,000 for $2,000 a month for 3 years. This also includes unlimited paper and toner as well as covers all maintenance. There is no purchase. However, the company had to pay an electrical contractor $3,000 to set up the proper electrical outlet for the copier. All lease payments were made on time.

    On 1/24/08, the company purchased with a company check 2000 company tote bags at $10 each plus 8.25% sales tax which they will give to their customers.

    On 2/24/08, the company purchased with a company check 5000 company tote bags at $12 each plus 8.25% sales tax.

    On 7/24/08, the company purchased with a company check 7000 company tote bags at $13 each plus 8.25% sales tax.

    At 12/31/08, there were only 2200 tote bags remaining.

    The sales people put on several promotional events during the year. The following lists the cash disbursements for those sales events:
    Trip 1- $33,250
    Trip 2- $23,100
    Trip 3- $15,789
    Trip 4- $21,879
    Trip 5- $22,789
    Trip 6- $34,457

    The company incurred and disbursed $10,000 per month in office expense.

    The federal income tax rate is 30%. The state income tax rate is 9%.

    The company will have six trips this year as listed below:

    Cash Receipts 2008:
    Trip 1 (6/1/08-6/7/08) $2,796,789
    Trip 2 (8/1/08-8/7/08) $2,892,112
    Trip 3 (12/26/08-1/2/09) $2,163,000
    Trip 4 (12/31/08-1/7/09) $2,877,265
    Trip 5 (4/1/09-4/7/09) $2,286,483
    Trip 6 (5/1/09-5/7/09) $895,680

    Total: $13,911,329

    Cash Receipts 2009:
    Trip 1- 1,232
    Trip 2- 854
    Trip 3- 8805
    Trip 4- 8,485
    Trip 5- 46,873
    Trip 6- 45,616
    Total: 111,865

    Cash Disbursements 2008 -For cost of tour expenses (hotels, meals, transportation, etc.)
    Trip 1- $2,412,794
    Trip 2- $2,228,202
    Trip 3- 2,246,507
    Trip 4- 1,448,695
    Trip 5- 1,797,477
    Trip 6- 799,394
    Total: $10,933,069

    Cash Disbursements 2009:
    Trip 1- 243
    Trip 2- 2,345
    Trip 3- 7,688
    Trip 4- 3,454
    Trip 5- 87,974
    Trip 6- 65,891
    Total: 167,595
    KRH31's Avatar
    KRH31 Posts: 4, Reputation: 1
    New Member
     
    #5

    Nov 30, 2009, 09:54 AM
    Also, here are my figures in case they are hard to read in the first post:

    Income Statement:

    Service Revenue = 7851901 (First 3 trips, not including Trip 4's unearned service revenue)

    Expenses:
    Cost of Tour 8,336,198
    Rent 42,000
    Salary 1,584,000
    Furniture and Equipment 82,125
    Depreciation 26,083
    Office Expenses 120,000
    Installation 16,000
    Advertising 185,107
    Promotional 94,018
    Interest 40,000
    Income Tax 3,062,241
    Insurance 54,000
    Payroll Tax 157,200

    Net Income: About -5,400,000


    (Incomplete) Statement of Cash Flows:

    Operating:
    Net Loss -5,400,000
    Depreciation 26,000
    Increase in Unearned Service Revenue 2,877,265

    Investing:
    Acquisition of plant assets (44,200)

    Financing:
    Long-Term Debt 1,225,200
    Common Stock 200,000

    Total: About $-1,300,000

    (Incomplete) Balance Sheet:

    Assets:

    Cash?? (A little confused as to how I find this.)
    Furniture, Fixtures, Equipment 82,125

    Liabilities:

    Unearned Service Revenue 2,877,265 (From Trip 4 which leaves Dec. 31, and ends about a week later)
    Income Tax Payable 3,062,241
    Lease Payments (?) 24,000
    Long-Term Debt 1,225,200
    Accrued Interest 42,520
    KRH31's Avatar
    KRH31 Posts: 4, Reputation: 1
    New Member
     
    #6

    Nov 30, 2009, 10:25 AM
    Let me try again. Maybe this will be easier to read:

    Requirement: Prepare a balance sheet, income statement, and statement of cash flow as of 12/31/08.

    The company takes people on tours around the world. When people sign up for a trip, they pay a deposit.
    The final payment is expected before the trips starts, but sometimes the company doesn't get paid until after the trip.
    The company has to make a deposit for hotels, airfare, etc. before the trip starts. Cost of tour expenses should be paid
    Before the start of the trip, but there are always last minute changes, so the company always has a few checks to
    Write after the trip ends.

    On 1/1/08, the two owners of the company each took out an equity loan from their home for $200,000 and
    Contributed it to the company in return for common stock. They also got a loan from a relative for
    $1,000,000 at 4% interest. They were told to pay the interest whenever they have the cash.
    The company did not make any interest payments during the year. The note is due in 5 years.

    On 1/11/08, they found an office space and signed a 3 year lease. January through May, rent will be free.
    Then rent will be $6,000 per month for the next year, then $7,000 per month for the remainder of the lease term.
    Rent is due at the beginning of each month. All rent payments were made on time.

    The company plans to have 15 employees including the two owners. On 1/11/08, they purchased 15 desks and
    Chairs for $275 each plus 8.25% sales tax plus $100 for shipping for all the 15 desks and chairs. The furniture
    Was received in the new office on 1/20/08. One of the owners paid for the desks and chairs in full with a company check.

    Also on 1/11/08, they ordered 15 computer workstations and printers. They would have cost $2,100 each including tax and
    Shipping, however, they decided to take out a loan which financed 80% of it at 10% amortized over 3 years.

    On 1/12/08, a wiring contractor came to the office and installed wiring for the computer and the phones at a cost of
    $6,000. One of the owners paid the contractor in full on 1/12/08.

    On 1/13/08, the company ordered business software amounting to $1,500
    Per computer. They also purchased a server for $5,000 plus sales tax.

    On 1/22/08, a computer consultant setup their computer system at a cost of $7,000.

    By 1/23/08, they had hired all their employees.

    On 1/24/08, one of the owners sent a company check for the software, server, and consulting time, in full.

    They will start work on 2/1/08, which will be considered the first day of business for the company.

    The company hired 2 salespeople with a monthly salary of $6,000 per month per person; 10 travel coordinators
    At $8,000 per month per person; and 1 administrative person at $4,000 per month. The two owners
    Will each make $18,000 per month.

    Payroll is paid monthly on the first working day after each month. Payroll tax expense is 10% of salaries.
    Each employee gets 2 weeks of vacation per year. During 2008, no one took vacation. All employees including
    The two owners officially started working on 2/1/08. All payrolls were paid on time. The company also pays for
    The employee's health insurance which is $300 per month per employee. This is due and payable on the first day
    Of every month. All health insurance payments were made on time.

    On 1/23/08, the company leased a copier which would normally cost $80,000 for $2,000 a month for 3 years.
    This also includes unlimited paper and toner as well as covers all maintenance. There is no purchase.
    However, the company had to pay an electrical contractor $3,000 to set up the proper electrical outlet
    For the copier. All lease payments were made on time.

    On 1/24/08, the company purchased with a company check 2000 company tote bags at $10 each plus 8.25% sales tax
    Which they will give to their customers.

    On 2/24/08, the company purchased with a company check 5000 company tote bags at $12 each plus 8.25% sales tax.

    On 7/24/08, the company purchased with a company check 7000 company tote bags at $13 each plus 8.25% sales tax.

    At 12/31/08, there were only 2200 tote bags remaining.

    The sales people put on several promotional events during the year. The following lists
    The cash disbursements for those sales events:
    Trip 1- $33,250
    Trip 2- $23,100
    Trip 3- $15,789
    Trip 4- $21,879
    Trip 5- $22,789
    Trip 6- $34,457

    The company incurred and disbursed $10,000 per month in office expense.

    The federal income tax rate is 30%. The state income tax rate is 9%.

    The company will have six trips this year as listed below:

    Cash Receipts 2008:
    Trip 1 (6/1/08-6/7/08) $2,796,789
    Trip 2 (8/1/08-8/7/08) $2,892,112
    Trip 3 (12/26/08-1/2/09) $2,163,000
    Trip 4 (12/31/08-1/7/09) $2,877,265
    Trip 5 (4/1/09-4/7/09) $2,286,483
    Trip 6 (5/1/09-5/7/09) $895,680

    Total: $13,911,329

    Cash Receipts 2009:
    Trip 1- 1,232
    Trip 2- 854
    Trip 3- 8805
    Trip 4- 8,485
    Trip 5- 46,873
    Trip 6- 45,616
    Total: 111,865

    Cash Disbursements 2008 -For cost of tour expenses (hotels, meals, transportation, etc.)
    Trip 1- $2,412,794
    Trip 2- $2,228,202
    Trip 3- 2,246,507
    Trip 4- 1,448,695
    Trip 5- 1,797,477
    Trip 6- 799,394
    Total: $10,933,069

    Cash Disbursements 2009:
    Trip 1- 243
    Trip 2- 2,345
    Trip 3- 7,688
    Trip 4- 3,454
    Trip 5- 87,974
    Trip 6- 65,891
    Total: 167,595

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!

Financial Statement with Balance sheet and income statement [ 1 Answers ]

Here's the problem: The Hobart Company incurred the following transactions during 2003: A. Acquired $50,000 of cash capital from owners B. Paid $10,000 to acquire manufacturing equipment C. Paid $5,000 cash for materials used in production D. Paid $2,000 for wages of production workers...

Financial Statement [ 1 Answers ]

For what purposes do external users use information of financial statements for?

What is the correct financial statement-statement of cash flows wording? [ 2 Answers ]

Cash (used) in operating activities <10,000> Cash (used) in investing activities 10,000 Thank you for any help you can provide.

Financial statement [ 1 Answers ]

How do you find the net income?

Financial Statement [ 1 Answers ]

You are in charge of a storage shed business. You recognize sales when the shed is fully installed in the customer’s yard. Your company takes 25% deposits on all orders. At the end of your accounting cycle, you have $500,000 in customer deposits. How do you state and properly account for this...


View more questions Search