Download the attached Excel file (First Q Profits Report W Goal Seek_Ver2.xlsx).Instructions:. There are 3 Worksheet Tabs in this Excel file; First Q, First Q Goal Seek, and Minivan Loan.• The First Q (First Quarter) tab shows the first quarter revenue and expenses of the Downtown Internet Cafe. For this tab,• Complete the Proportion column, cells G7 through G11 Each proportion value shows the % of the quarterly sale of that item over the entire sale.Calculate the Net Income row, cells B24 through F24.o Compute the Profit Margin row, Cells B25 through E25.o Add Net Income Sparkline for January through March in Cell H24.in For this tab 234567 Espresso8910 Merchandise11Computer12 Total SalesSalesDrip CoffeeFood/Beverage13 Expenses14 Cost of Goods15 Cost of Merchandise16 Payroll17 Internet18 Building19 Advertising20212223 IncomeCapital AssetsMiscellaneousTotal Exp24 Net Income25 Profit Margin26BDowntown Internet CaféFirst Quarter Forecast$$JANFEBMAR17,580 $17,750 $3,710 $3,080 $$12,000 $ 12,000 $$325 $325 $$2,100 $2,100 $$600 $600 $$ 1,500 $1,500 $$1,300 $1,300 $$26,400 $ 27,200 $ 26,500 $ 80,100 $26,700$ 14,400 $ 14,500 $ 14,800 $43,700 $14,567$32,900 $10,96711,100 $5,300 $1,050 $11,0004,400 $$14,200 $4,733$1,165 $3,460 $ 1,153$ 58,250 $58,265 $174,360 $58,120$10,800 $4,500 $1,245 $57,845 $17,545 $3,150 $12,000 $325 $2,100 $600 $1,500 $1,300 $TOTALAVG27 Student's Name:KAYA First Q First Q Goal Seek Minivan Loan52,875 $17,6259,940 $3,31336,000 $12,000975 $3256,300 $2,1001,800 $ 6004,500 $1,5003,900 $1,300$ 58,250 $ 58,265 $ 57,845 $ 174,360 $58,120ProportionProportion showsthe ratio (%) of eachsales item over theTotal Sales.Add Net IncomeSparkline for themonths of Jan. toMar. in Cell H24.

Total sales are defined as the amount an entity collects by trading all of its products. It means if…

2 3 4 5 6 Sales 7 Espresso 8 Drip Coffee 9 Food/Beverage 10 Merchandise 11 Computer 12 Total Sales 13 Expenses 14 15 16 Payroll 17 Internet 18 Building 19 20 21 22 23 Income 24 Net Income 25 Profit Margin 26 Cost of Goods Cost of Merchandise Advertising Capital Assets Miscellaneous Total Exp 27 Student's Name: K‹ First Q $ $ $ $ $ $ $ S $ Downtown Internet Café First Quarter Forecast JAN FEB 26,400 $ 27,200 $ 26,500 $ 14,400 $ 14,500 $ 14,800 $ 11,100 $ $10,800 $ 11,000 4,400 $ 5,300 $ 4,500 $ 1,050 $ 1,165 $ 1,245 $ 58,250 $ 58,265 $ 57,845 $ $ $ $ $ $ 1,300 $ MAR 17,580 $ 3,710 $ 12,000 $ 12,000 325 $ 325 $ 2,100 $ 2,100 $ 600 $ 600 $ 1,500 $ 1,500 $ 1,300 $ 17,750 $ 17,545 $ 3,080 $ 3,150 $ $12,000 $ 325 $ 2,100 $ 600 $ 1,500 $ 1,300 $ $ 58,250 $ 58,265 $ 57,845 $ TOTAL First Q Goal Seek Minivan Loan P AVG 80,100 $26,700 43,700 $14,567 32,900 $10,967 14,200 $4,733 3,460 $ 1,153 174,360 $58,120 52,875 $17,625 9,940 $3,313 36,000 $12,000 325 975 $ 6,300 $2,100 1,800 $ 600 4,500 $1,500 3,900 $1,300 174,360 $58,120 Proportion Proportion shows the ratio (%) of each sales item over the Total Sales. Add Net Income Sparkline for the months of Jan. to Mar. in Cell H24.

2 3 4 5 6 Sales 7 Espresso 8 Drip Coffee 9 Food/Beverage 10 Merchandise 11 Computer 12 Total Sales 13 Expenses 14 15 16 Payroll 17 Internet 18 Building 19 20 21 22 23 Income 24 Net Income 25 Profit Margin 26 Cost of Goods Cost of Merchandise Advertising Capital Assets Miscellaneous Total Exp 27 Student's Name: K‹ First Q $ $ $ $ $ $ $ S $ Downtown Internet Café First Quarter Forecast JAN FEB 26,400 $ 27,200 $ 26,500 $ 14,400 $ 14,500 $ 14,800 $ 11,100 $ $10,800 $ 11,000 4,400 $ 5,300 $ 4,500 $ 1,050 $ 1,165 $ 1,245 $ 58,250 $ 58,265 $ 57,845 $ $ $ $ $ $ 1,300 $ MAR 17,580 $ 3,710 $ 12,000 $ 12,000 325 $ 325 $ 2,100 $ 2,100 $ 600 $ 600 $ 1,500 $ 1,500 $ 1,300 $ 17,750 $ 17,545 $ 3,080 $ 3,150 $ $12,000 $ 325 $ 2,100 $ 600 $ 1,500 $ 1,300 $ $ 58,250 $ 58,265 $ 57,845 $ TOTAL First Q Goal Seek Minivan Loan P AVG 80,100 $26,700 43,700 $14,567 32,900 $10,967 14,200 $4,733 3,460 $ 1,153 174,360 $58,120 52,875 $17,625 9,940 $3,313 36,000 $12,000 325 975 $ 6,300 $2,100 1,800 $ 600 4,500 $1,500 3,900 $1,300 174,360 $58,120 Proportion Proportion shows the ratio (%) of each sales item over the Total Sales. Add Net Income Sparkline for the months of Jan. to Mar. in Cell H24.

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter22: Master Budget (master)

Section: Chapter Questions

Problem 2R: Open the file MASTER from the website for this book at cengagebrain.com. Enter all the formulas...

See similar textbooks

Similar questions

Open the file MASTER from the website for this book at cengagebrain.com. Enter all the formulas where indicated on the worksheet. Check to be sure that your balance sheet balances. Enter your name in cell A1. Save the completed file as MASTER2. Print the worksheet when done. Also print your formulas using fit-to-1 page scaling. Check figures: Borrowing (cell B78), $7,280; forecasted net income (cell D95), $40,200; total assets (cell D105), $507,600.
-jasoniabattles@cont x udentFunctions/Interface/acellus_engine.html?ClassID=980092141 K to 12 6 BS Acellus - The Scienc M My Gmail B My Classes S My Drive-Google D.. Average Daily Balance Interest Calculation The balance on a credit card, that charges a 20% APR interest rate, over a 1 month period is given in the following table: $150 (initial balance) Days 4-20: $200 ($50 purchase) ($150 payment) Days 1-3: Days 21-30: $50 What is the finance charge, on the average daily balance, for this card over this 1 month period? finance charge $ [?] Round to the nearest hundredth. Enter Corporation All Rights Reserved.
In cell B10, enter a formula using the IF and AND functions to indicate whether the revenue goal has been met that month: a. Enter the logical test using the AND Function to determine if the Fundraisers amount in cell B7 equals 0 and the Total in cell B8 is greater than 20,000. b If the logical test is true, display Yes (using "Yes" for the value_if_true argument). c. If the logical test is false, insert a nested IF function. d. Enter the logical test of the nested IF function using the AND function to determin if the Fundraiser amount in cell B7 is greater than 0 and the Total in cell B8 is greater than 200,000. e. If the logical test for the nested IF function is true, display YES ( using "Yes" for the value_if_true argument). f. If the logical test if false, display No (using "No" for the value_if_false argument) I have tried to figure this excel formula out for about an hour now, this is what I have. but this is only half of the formula. I need the correct formula please.…
Application Time! 1) You will type the TVM inputs in the table provided from the "Info Sheet". 2) Mirror the inputs from the "Info Sheet" to the TVM cells provided. 3) Within the TVM cells, if needed, compound. 4) In the "ANSWER" cell show us your TVM calculation. Goal 1: Opened an account with $1500, with the hope to have a total of $2500 saved in an LG2-Q8 emergency fund within one year (no additional payments). What would the quarterly interest rate be needed to reach this goal? Goal 2: A credit card balance of $2000 with an 15% rate. The goal is to pay off the credit card LG2-Q9 by the end of the year. (future is a $0 balance) What would be the monthly payment to reach this goal? Goal 3: Student loan balance of $18,000 at 6.5% and making $425 monthly payments. (future LG2-Q10 is a $0 balance) How many months will it take to complete this goal? in fuo (no Compounding Number (select from dropdown) 4 Compounding Number (select from dropdown) 12 Compounding Number (select from…
Accounting Question
engageNOWv2 | Online teachir X * CengageNOWv2| Online teachir x .com/ilrm/takeAssignment/takeAssignmentMain.do?invoker=&takeAssignmentSessionLocator=&inprogre. * A eBook Show Me How Accounts Receivable Analysis A company reports the following: Sales $671,600 Average accounts receivable (net) 67,160 Determine (a) the accounts receivable turnover and (b) the number of days' sales in receivables. Round interim calculations to the nearest dollar and final answers to one decimal place. Assume a 365-day year. a. Accounts receivable turnover b. Number of days' sales in receivables days Previous Next Check My Work 11:16 AM 67°F Sunny A O E D a ) 12/3/2021 n sc hone backsoce
Journalize this transaction: Paid $320 to Ameren for the monthly bill. Edit View Insert Format Tools Table 12pt v Paragraph v В I U MacBook Pro Oine Fi En ACCT 101 Onre le Oa01 for Ais eet # $ % & 3.
Solar Solutions began operations on January 1, 2015, and is now in its sixth year of operations. It is a retail sales company with a large amount of online sales. The adjusted trial balance as of December 31, 2020 appears below, along with prior year balance sheet data and some additional transaction data for 2020. SOLAR SOLUTIONS Adjusted Trial Balance 12/31/2020 2020 2019 Account Title Adjusted Trial Balance Post-Closing Trial Balance Debit Credit Debit Credit Cash $ 122,200 55,000 125,600 Accounts Receivable 35,000 Prepaid Insurance 5,000 6,000 |Inventory Office Equipment Machinery & Tools Accumulated Depreciation Accounts Payable Salaries Payable Sales Tax Payable Note Payable-Long Term Common Stock, $10 par 46,000 15,600 63,000 47,000 59,000 21,000 21,000 16,000 11,200 16,800 2,600 2,700 2,000 4,000 31,000 22,100 240,000 160,000 Retained Earnings 28,600 28,600 Dividends 10,000 Sales Revenue Cost of Goods Sold Rent Expense Salaries Expense 235,000 127,600 20,000 36,000 Insurance…
You are assigned as the financial advisor of the would-be entrepreneur James Udderlie. Write a 100-wordreport of the possibilities of James getting a loan for hisnew business.Type your report below (you may attach tables /appendices / calculations as you see fit). Be mindful ofthe word limit. Do not send PDF document formatreport. You may like to consider some template toframe your answer e.g., 5 "C" (condition / collateral /capacity / character/ capital; 4 Ps (Price / Product /Promotion / Place); or SWOT (Strength / Weakness /Opportunity / Threat).
Complete the following problems on an excel spreadsheet. Number your problems on a different tab. PA3 requires two special journals and a subsidiary ledger. PA3. The following transactions occurred for Donaldson Inc. during the month of July. Record the transactions for Donaldson Inc. in the proper special journal and subsidiary ledger. Jul. 1 Sold 50 items to Palm Springs Inc. and offered terms of 2/10, n/30, $4,000 on July 1, and issued invoice #12 on account number #312 Jul. 5 Sold 20 thing-a-jigs to Miami Inc. for $2,150 cash on July 5, and issued invoice #13 Jul. 8 Sold 30 what-is to Smith Mfg. for $5,000 and offered terms of 2/10, n/30; issued invoice #14 on account number #178 Jul. 9 Received payment from Palm Springs Inc. Jul. 22 Received payment from Smith Mfg. after expiration of the discount period
Instructions 1. Download the Chart workbook from Google Classroom. 2. Insert a Line chart into our practice Word document. 3. Open our Chart workbook in Excel. Copy the data and paste it into the chart's spreadsheet.4. Change the chart title to Monthly Sales. 5. Change the chart type to Stacked Column.6. Double-click the axis title, then rename it Sale Profits.
Social Media, Inc. (SMI) has two services for users. Toot!, which connects tutors with students who are looking for tutoring services, and TiX, which can be used to buy, sell, or exchange event tickets. For the following year, SMI expects the following results. Toot! TiX Total Users 10,700 18,100 28,800 Revenues $ 1,600,000 $ 1,440,000 $ 3,040,000 Engineering hours 8,200 6,200 14,400 Engineering cost $ 516,500 $ 635,500 $ 1,152,000 Administrative costs $ 921,600 Required: Compute the predetermined overhead rate used to apply administrative costs to the two services assuming SMI uses the number of usersto allocate administrative costs. Based on the rates computed in requirement (a), what is the profit for each service?