Excel Applications for Accounting Principles
4th Edition
ISBN: 9781111581565
Author: Gaylord N. Smith
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Question
error_outline
This textbook solution is under construction.
Students have asked these similar questions
Complete your calculations by filling in the highlighted cells. Discuss your observations about the way cash is collected if the company needs $150,000 per month for expenses.
Mary began a business, and after collecting $30,000 from an equity investor and borrowing $15,000 from a bank, she purchased piece of land for $40,000. During the year, she leased the land to Karl and received $12,000 in cash, paying $14,000 cash for expenses. She paid a $1,000 dividend to the equity investor at year.-end
Prepare an income statement, a statement of shareholders’ equity, a balance sheet, and a statement of cash flows for the period. Evaluate Mary’s decision to pay the $1,000 dividend.
PLEASE, PERFORM THE EXERCISE IN EXCEL AND SHOW THE FORMULASPLEASE, PERFORM THE EXERCISE IN EXCEL AND SHOW THE FORMULASPLEASE, PERFORM THE EXERCISE IN EXCEL AND SHOW THE FORMULAS
(Not written.. please)
Empresa Comercial El Europeo, S.A., hires you because of the "good" references of your professor of the Financial Administration course, because he wants to know how much and at what time your cash needs will be manifested in the following semester as of January 1st. For which he provides the following:
Sales are made 25% cash and 75% on credit. Of the credit sales, 75% is collected one month after the sale, and the remaining 25% two months later.You buy in a given month what you expect to sell the following month. The material cost is 45% of sales. The supplier gives the conditions of 60% cash and the other 40% the month after the purchase.Provisional tax payments are calculated, considering 1.25% of each month's sales and are paid the month following the month of sale.It is desired to…
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Similar questions
- PLEASE, PERFORM THE EXERCISE IN EXCEL AND SHOW THE FORMULASPLEASE, PERFORM THE EXERCISE IN EXCEL AND SHOW THE FORMULASPLEASE, PERFORM THE EXERCISE IN EXCEL AND SHOW THE FORMULAS (Not written.. please) Empresa Comercial El Europeo, S.A., hires you because of the "good" references of your professor of the Financial Administration course, because he wants to know how much and at what time your cash needs will be manifested in the following semester as of January 1st. For which he provides the following: Sales are made 25% cash and 75% on credit. Of the credit sales, 75% is collected one month after the sale, and the remaining 25% two months later.You buy in a given month what you expect to sell the following month. The material cost is 45% of sales. The supplier gives the conditions of 60% cash and the other 40% the month after the purchase.Provisional tax payments are calculated, considering 1.25% of each month's sales and are paid the month following the month of sale.It is desired to…arrow_forwardJohn Marshall is employed as a bank loan officer for First State Bank. He is comparing two companies that have applied for loans, and he wants your help in evaluating those companies. The two companies—Morris, Inc., and Walker Company—are approximately the same size and had approximately the same cash balance at the beginning of 2009. Because the total cash flows for the three-year period are virtually the same, John is inclined to evaluate the two companies as equal in terms of their desirability as loan candidates. Abbreviated information (in thousands of dollars) from Morris, Inc., and Walker Company is as follows: Morris, Inc. Walker Company 2009 2010 2011 2009 2010 2011 Cash flows from: Operating activities $10 $13 $15…arrow_forwardBlue Company, an architectural firm, has a bookkeeper who maintains a cash receipts and disbursements journal. At the end of the year (2019), the company hires you to convert the cash receipts and disbursements into accrual basis revenues and expenses. The total cash receipts are summarized as follows. The accounts receivable from customers at the end of the year are 120,000. You note that the accounts receivable at the beginning of the year were 190,000. The cash sales included 30,000 of prepayments for services to be provided over the period January 1, 2019, through December 31, 2021. a. Compute the companys accrual basis gross income for 2019. b. Would you recommend that Blue use the cash method or the accrual method? Why? c. The company does not maintain an allowance for uncollectible accounts. Would you recommend that such an allowance be established for tax purposes? Explain.arrow_forward
- The following historical information is from Assisi Community Markets. Calculate the working capital and current ratio for each year. What observations do you make, and what actions might the owner consider taking?arrow_forwardMichael Anderson is starting his computer programming business and has deposited in initial investment of $15,000 into the business cash account. Identify how the accounting equation will be affected.arrow_forwardIn early December Alice and Bob decided to open Sample Cafe with $14,000 of their own money and $19,000 borrowed from a friend. They have spent $11,000 on equipment and furniture, and they have purchased $2,800 worth of cups for cash which they expect will be used over the next three months. Having put down a $2,400 deposit for a location on Main St., they will pay the first month’s rent when they open their doors on January 1. In the balance sheet template below, fill in the appropriate values as of December 31.arrow_forward
- The president of the retailer Prime Products has just approached the company’s bank with a request for a$30,000, 90-day loan. The purpose of the loan is to assist the company in acquiring inventories. Becausethe company has had some difficulty in paying off its loans in the past, the loan officer has asked for a cashbudget to help determine whether the loan should be made. The following data are available for the monthsApril through June, during which the loan will be used:a. On April 1, the start of the loan period, the cash balance will be $24,000. Accounts receivable onApril 1 will total $140,000, of which $120,000 will be collected during April and $16,000 will becollected during May. The remainder will be uncollectible.b. Past experience shows that 30% of a month’s sales are collected in the month of sale, 60% in themonth following sale, and 8% in the second month following sale. The other 2% represents bad debtsthat are never collected. Budgeted sales and expenses for the…arrow_forwardJorge Martinez is thinking about buyingan existing printing business and hasbeen carefully studying the records of thebusiness to get a good handle on its historicalfinancial performance. Jorge heardthat you are taking a class in entrepreneurshipand asks you, “What suggestionsdo you have for me to make the best use ofthis financial information (i.e., three yearsof audited income statements, balancesheets, and statements of cash flow)?”What suggestions would you give Jorge formaking the maximum use of the financialstatements?arrow_forwardKampfire, Inc., a very successful manufacturer of camping equipment, is considering going public next month to raise funds to help finance the company’s futuregrowth. The financial manager of Kampfire has approached the investmentbanking firm at which you work seeking help with its decision. Your boss askedyou to explain the nature of the U.S. financial markets and the process of issuingequity to the financial manager. To help with this task, your boss has asked youto answer the following questions in explaining the U.S. financial system to thefinancial manager:a. What is a financial market? How are financial markets differentiated frommarkets for physical assets?b. Differentiate between money markets and capital markets.c. Differentiate between a primary market and a secondary market. If Microsoftdecided to issue additional common stock and an investor purchased 1,000shares of this stock from the underwriter, would this transaction be a primarymarket transaction or a secondary market…arrow_forward
- On January 1, 2019, Sharon Matthews established Tri-City Realty, which completed the following transactions during the month: Sharon Matthews transferred cash from his personal bank account to a new account to start a new business, $40,000. Paid rent on office for the month, $6,000. Purchased supplies on account, $3,200. Paid creditor on account, $1,750. Earned fees, receiving cash, $18,250. Paid automobile expenses (including rental charge) for month, $1,880, and miscellaneous expenses, $420. Paid office salaries, $5,000. Determined that the cost of supplies used was $1,400. Withdrew cash for personal use, $2,000. Instructions Journalize entries for transactions (1) through (9), using the following account titles: Cash; Supplies; Accounts Payable; Capital; Drawing; Fees revenues; Rent Expense; Office Salaries Expense; Automobile Expense; Supplies Expense; Miscellaneous Expense. (Explanations may be omitted). Prepare T accounts, using the account titles in (1). Post the journal…arrow_forward. PQR is the accounting intern for, a firm that has many small clients that need monthly accounting services. Ray has been asked by the partner in charge to analyze the asset section of firm’s balance sheets which follow: 2011 2012 Cash $2,500 $3,900 Accounts receivable, net 35,000 40,000 Inventory 85,000 122,000 Other current assets 3,400 4,110 Total current assets 125,900 170,010 Property , plan &equipment , net 180,000 230,000 Other assets 15,000 26,000 Total assets $320,900 $426,010 Required Prepare a common-size analysis of the assets section of the firm’s balance sheet for 2011 and 2012.Round all percentage answers to one decimal placearrow_forwardAssume that you are nearing graduation and that you have applied for a job at a local bank. As part of the bank’s evaluation (interview) process, you have been asked to take an exam that covers several financial analysis techniques. The hiring decision depends on how you would answer the following questions: Part I: TVM Analysis. The first section of the test addresses time value money analysis.John andMaryareayoungcouple, who want to put their finance in order. Boththehusbandandthe wifeare27yearsagoandinstableemployment. They want to manage their savings and earnings to achieve a better return and reduce the risks. You want to help them with their financial planning by answering a series of questions as follows: ThegreatAlbertEinsteinoncesaid“Compoundinterestistheeighthwonderofthe world. He who understands it earns it...he who doesn't...pays it.” Whatisthefuture value of an initial $500 after 30 years if it is invested in an account paying 15 percent annual interest? What is the…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage LearningIndividual Income TaxesAccountingISBN:9780357109731Author:HoffmanPublisher:CENGAGE LEARNING - CONSIGNMENT
- College Accounting, Chapters 1-27AccountingISBN:9781337794756Author:HEINTZ, James A.Publisher:Cengage Learning,Principles of Accounting Volume 1AccountingISBN:9781947172685Author:OpenStaxPublisher:OpenStax College
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
Individual Income Taxes
Accounting
ISBN:9780357109731
Author:Hoffman
Publisher:CENGAGE LEARNING - CONSIGNMENT
College Accounting, Chapters 1-27
Accounting
ISBN:9781337794756
Author:HEINTZ, James A.
Publisher:Cengage Learning,
Principles of Accounting Volume 1
Accounting
ISBN:9781947172685
Author:OpenStax
Publisher:OpenStax College
Property, Plant and Equipment (PP&E) - Introduction to PPE; Author: Gleim Accounting;https://www.youtube.com/watch?v=e_Hx-e-h9M4;License: Standard Youtube License