The financial statements must be complete and in good form using Excel (or similar spreadsheet). The adjusted? related questions

Asked by
The financial statements must be complete and in good form using Excel (or similar spreadsheet). The adjusted?0harvey2012-07-28 19:08:59
The financial statements must be complete and in good shape to use Excel (spreadsheet or similar). The adjusted trial balance of Myra Co. at December 31, 2009, is as follows Myra Company Adjusted trial balance December 31, 2009 Account # Title Credit Debit 101 in cash $ 7,500 104 Short-term investments $ 23,500 Sources 126 $ 8,100 128 Prepaid Insurance $ 8,600 167 Equipment $ 40,000 168 Accumulated Depreciation-Equipment $ 20,000 $ 177,000 173 Building 174 Accumulated Depreciation-Building $ 59,000 183 Land $ 68,120 201 Accounts payable $ 17,000 203 $ 3,000 Interest payable 208 $ 3,500 Income payable 210 Salaries pay $ 2,500 Property Taxes 213 pay $ 1,300 233 professional fees of $ 7,900 Unearned 251 long-term notes payable $ 64,500 301 S. Look, Capital $ 132,600 302 S. Look, $ 10,300 retirement 401 Professional fees $ 104,000 accrued 406 Rental won $ 18,000 407 $ 2,500 Dividends received 409 Interest $ 2,300 606-Building Depreciation expense $ 12,980 612 Depreciation of equipment costs $ 6,000 623 Salaries expense $ 27,500 633 Interest expense $ 3,800 637 Insurance expense $ 7700 640 Rental expense $ 11,300 652 Supplies expense $ 6100 682 postage of $ 2,800 683 property tax expense $ 3,400 684 Repairs expense $ 6,900 Phone 688 expense $ 3200 690 Utilities $ 3300 expense Amounts to $ 438,100 $ 438,100 Myra S. invested $ 7,500 cash in the company during the year 2009 (December 31, 2008, balance in favor of Myra S., capital account $ 125,100). Myra Company is required to make a payment of $ 6,000 in their long-term notes payable during 2010. Total assets (12/31/2009), $ 253,820, net income, $ 31,820 Required 1) Prepare the income statement and statement of owner
How do I calculate Internal Rate of Return in an excel spreadsheet?0ã„‘ hate Math 2012-05-08 14:05:41
Hello - I have to answer the following problems in an excel spreadsheet and do not know how. Any advice , suggestions and help is appreciated. 1 . Calculate the internal rate of return ( IRR ) requires cash flow of ten annual deposits of $ 10,000 from the beginning of the first year and resulting in a future value of $ 400,000 at the end of year 20. 2 . Calculate the future value as of 12/31/2028 $ 10,000 deposited per year for 10 years from 1/1/2000, growing at a gross rate of 11.5 % annually, but with 100 % growth taxes each year, assuming a 40% tax expense. Thank you !
How do you complete Preparing Entries and Statements?0Angeliqua2012-08-02 11:23:52
I have an assignment doing for preparing entries and statements. I am so confused and don't understand how to do this. Resources: Fundamental Accounting Principles, pp. 165-167. Complete problems 4-5A and 4-6A. When responding to the analysis component of 4-5A, think critically about the possible errors that are described. In your answer, carefully analyze the worksheet as if the errors were made and present the evidence for you explanation. Identify the consequences of the errors and describe their affect on the financial statements. Explain whether the error is likely to be discovered when completing the worksheet. The following unadjusted trial balance is for Adams Construction Co. as of the end of its 2005 fiscal year. The June 30, 2004, credit balance of the owner's capital account was $52,660, and the owner invested $25,000 cash in the company during the 2005 fiscal year. Adams Construction Co. Unadjusted Trial Balance June 30, 2005 No. Account Title Debit Credit 101 Cash $17,500 126 Supplies 8,900 128 Prepaid insurance 6,200 167 Equipment 131,000 168 Accumulated depreciation-Equipment $25,250 201 Accounts payable 5,800 203 Interest payable 0 208 Rent payable 0 210 Wages payable 0 213 Property taxes payable 0 251 Long-term notes payable 24,000 301 S. Adams, Capital 77,660 302 S. Adams, Withdrawals 30,000 401 Construction fees earned 134,000 612 Depreciation expense-Equipment 0 623 Wages expense 45,860 633 Interest expense 2,640 637 Insurance expense 0 640 Rent expense 13,200 652 Supplies expense 0 683 Property taxes expense 4,600 684 Repairs expense 2,810 690 Utilities expense 4,000 Totals $266,710 $266,710 Required: 1. Prepare a 10-column work sheet for fiscal year 2005, starting with the unadjusted trial balance and including adjustments based on these additional facts: a. The supplies available at the end of fiscal year 2005 had a cost of $3,200. b. The cost of expired insurance for the fiscal year is $3,900. c. Annual depreciation on equipment is $8,500. d. The June utilities expense of $550 is not included in the unadjusted trial balance because the bill arrived after the trial balance was prepared. The $550 amount owed needs to be recorded. e. The company's employees have earned 1,600 of accrued wages at fiscal year-end. f. The rent expense incurred and not yet paid or recorded at fiscal year-end is $200. g. Additional property taxes of $900 have been assessed for this fiscal year but have not been paid or recorded in the accounts. h. The long-term note payable bears interest at 1% per month. The unadjusted Interest Expense account equals the amount paid for the first 11 months of the 2005 fiscal year. The $240 accrued interest for June has not yet been paid or recorded. (Note that the company is required to make a $5,000 payment toward the note payable during the 2006 fiscal year.) 2. Use the work sheet to enter the adjusting and closing entries; then journalize them. 3. Prepare the income statement and the statement of owner's equity for the year ended June 30 and the classified balance sheet at June 30, 2005.
Car Insurance claim form statements?0islam2012-11-05 01:28:32
True statements submitted to Insurance companies: These are the answers to the bit: "Describe in your own words how the accident occured". 1/ The accident was caused by me waving to the man I hit last week 2/ Coming home from work, I drove into the wrong driveway and collided with a tree I haven't got 3/ The pedestrian was all over the road; I had to swerve a number of times before I hit him. 4/ I drove into a lamp-post which was obscured by human beings. 5/ I knocked over a man; He admitted it was his fault as he'd been knocked over before. 6/ The pedestrian had no idea which way to run, so I ran over him And my personal favourite: " I first noticed the slow-moving, sad-faced old gentleman as he bounced of the bonnet of my car !" Cheers (Ref: Jasper Carrott - who collects these statements as a hobby)
What are the main differences between the financial statements of the following businesses Insurance Banking and Hotels0Xzibit 2012-03-19 03:00:49
What are the main differences between the financial statements of the Banking and Insurance companies the following hotels
Auto insurance reimburses lost time at work, HR refuses to complete form?0Loe2012-09-20 14:15:04
Assume the following facts: Person gets in auto accident, his fault, and misses work the next day for 6 hours for a medical evaluation (he is paid by the hour). His insurance company reimburses for lost wages from work for this purpose, and they provide him with a form that his employer's HR must complete, indicating hourly wage. His employer refuses to complete the form for the insurance company. They cited no reasons for their refusal. The week that he missed work, he did work 40 hours. However, he habitually works works 5-10 hours of overtime during a given week. Because of that, he did lose out on potential wages. MN law applies. Are the employer's actions appropriate? As a matter of law, what principles apply that support the employee compelling the employer to complete the form. Likewise, on what grounds does the employer invoke in refusing the complete the form. Thanks!
How long do you keep important papers such as bank statements, receipts for bills, insurance statements etc?0Marzi2012-10-15 10:00:25
Going through the papers and documents and some date after 2008. Not sure what to keep and get rid of it . Does anyone have a general idea of ​​how long to retain documents, such as invoices , bank statements , etc. .
What type of documentation should i provide on my financial aid appeal form for college?0Li2012-08-29 14:53:15
Hello. I recently attended Glendale Community College and now in search of my sophmore year.y last semester GPA did not do so well so I learned were suspended financial aid ( until further notice) and have to make an appeal form with order to get my money back. In my family , my father had an incident in which he fell from a second and broke his CV , long story short I had and went to Valley Hospice Surgey strength training and rehabilitation. We did not have any health insurance so my family was in a kind of financial crisis . Through my choice , I decided to work with a family man and take 30% of his salary as a generous guy for help. My father later got discharged from the rehabilitation center aand hoe was in home care until he reached a full recovery . So I was busy with getting some money to help , and sometimes even the care of my father and put everything aside not going to school or even sometimes misssing deadlines for schoolwork and homework. I have done the CNA that home care of my father and RN (nurse ) willing to do anything to help me in my appeal form.knowing have had problems and was a little difficult therefore , my grades dropped and I put em culdnt at the time I thought I could . My question is , health wise , what kind of documentation or medical statements CNA or RN can provide to help with my appeal ? Much is electronic and there are some conditions on the information that can be released to another. Any information is greatly appreciated thanks for your help :)
A question on complete comfort vs. complete freedom?0Jordaiah2012-10-25 21:08:59
I thought about doing this again here for more diversity of opinion, but it seems that everyone in the government section leans right MedlinePlus. MedlinePlus I'll describe two scenarios and I want you to tell me which scenario you prefer to live in and why. Also, please include your age, sex, country and political affiliation. MedlinePlus MedlinePlus Scenario A: MedlinePlus MedlinePlus Your government (and its citizens through a majority vote) has decided that all citizens should have the basic necessities. Every citizen is given a car and a house to meet your needs. The car is one that is safe, reliable and gets the best gas mileage. You are allowed limited options, such as color and if you want a door convertible, two or four doors, and other options are allowed for those in need, such as pickup trucks for farmers, minivans for large families and features handicapped accessibility. Households also receive meets your needs, with few options, and if the house does not meet your needs you may be asked to move (but in the same city), and if you have children, you can move to a bigger house, when they grow there to move to a smaller house. They also provide healthy food, free and you have the option of buying junk food with their own money if they want. There are however allowed to buy bigger cars or homes due to environmental impact. Also provided public services by up to a certain limit and maintaining petrol and car (you are free to buy more utilities and gasoline from its own income, if desired). Health education is also provided to every citizen, as well as clothing for job interviews and employment (other clothing can of course be purchased by the individual) and free school uniforms for school children. Child care is covered for everyone and so is the attention MedlinePlus the elderly, the sick and the disabled, such as home health, hospice, nursing homes and retirement homes. MedlinePlus No taxes for anyone making less than $ 250,000 per year, and subsidies for up to 250k 200k income for families and for people who work full time and not do much. People who earn more than taxed, and very rich with more than a million dollars are taxed heavily. MedlinePlus MedlinePlus Scenario B: MedlinePlus MedlinePlus You live in a complete system with full freedom and individual responsibility. Government exists only to curb serious crime (murder and rape - no more laws against drugs, prostitution and other crimes, and private property is the individual's responsibility to protect) and provide military. Everything is in the hands of the private sector, including schools, roads and fire. You have to pay for children to go to school, you must subscribe to firefighters to use their services, including care in the emergency room does not lend itself to the uninsured. No more public libraries - no rental of privately owned books instead. You must also pay tolls on all roads leading because they are all privately owned. However, there are no taxes other than sales tax to fund the police and army.
Good Financial And Account Service Provider1TerryStewart2017-01-30 23:51:16
Where can one find a good financial and account service provider?
How to start life off on a good financial foot?0Angeline2012-09-07 04:19:03
Hi, I have 17 years . I was recently admitted to Columbia University with the help of this podcast.So , I'm moving to the next stage in life , pay for college / worry about money . ( Wait , money does not grow on trees ? ! ? ! ? ! ? ! ) How I can make sure I start off budget adulthood . What are some things we all wish we had known about money before. I am applying to tons of scholarships and Columbia estimated financial aid package covering about $ 32,000 of the $ 52,000 account . I know my parents are getting life insurance as a graduation gift and I have no health insurance , but I need other insurance ? I know very little about money . If I left the information you need to help me I will be happy to find it for you . Thank you.
If i print a poxy form is it just as good as if i went to the license bureau?1And2012-02-24 03:40:24
If you print a poxy form is as good as if I were to leave office ?

Ask New Question  

  • You are not logged in,answer will be Anonymous.Set Nickname | Sign In | Sign Up
  • tags separate by ','
  • Shortcuts:Ctrl+Enter

Latest Questions