Archives
Accounting Chapter 1 Row Labels Sum of Order Amount Costco
September Sales Sales Order ID Customer Order Date Order Amount Salesperson Store Location 50325 Target 9/1/2017 73,192$ F. Lemming CA 50326 Wal-Mart 9/1/2017 51,924$ S. Moore FL 50327 Kmart 9/2/2017 39,419$ G. Sammy AZ 50338 Wal-Mart 9/16/2017 22,663$ R. Clemens […]
Accounting Chapter 10 Input masks are tools in Access that are used
tables are valid and that you don’t accidentally delete or change related data. 10. Three rules are followed when referential integrity is enforced: 1) values entered into a foreign field table must exist in the primary field table, 2) you […]
Accounting Chapter 11 Wildcards Are Used Queries Allow The User
1 | P a g e CHAPTER 11 QUERIES CHAPTER 11 QUESTIONS 1. The query wizard will ask you what tables and fields you want to include in a query and what level of summarization is required. The design view […]
Accounting Chapter 12 An existing relationship must be deleted before
1 | P a g e CHAPTER 12 FORMS CHAPTER 12 QUESTIONS 1. The Design View is used to edit an existing form. 2. Bound controls get their data from fields in a table. Unbound controls are independent and their […]
Accounting Chapter 13 Count Function Used Count Records Report Count
1 | P a g e CHAPTER 13 REPORTS CHAPTER 13 QUESTIONS 1. Printed queries don’t format very well. They can be sorted, but they didn’t have the header, footer, grouping or summarizing features of reports. 2. No you can’t. […]
Accounting Chapter 2 Advertising expense Sales revenue Cost of goods sold
Account Dr. Cr. Cash 25,412.35$ Accounts receivable 84,245.25 Inventory 125,351.45 Prepaid expenses 15,625.26 What SUP, Inc. Trial Balance December 31, 2018 Supplies 10,245.15 Land 120,000.00 Building 300,000.00 Accumulated depreciation: Building 60,000.00$ Equipment 65,000.00 Accumulated depreciation: Equipment 8,000.00 Accounts payable 75,182.10 […]
Accounting Chapter 2 Be My Baby Peach Drift Climbing Orange Crush
Rosey’s Roses Inventory Type Description Quantity Cost/Unit Cost Shrub Abraham Darby #5 25 $39.99 $999.75 Shrub Be My Baby #5 40 $18.99 $759.60 Shrub Deja Blu #5 18 $25.99 $467.82 Shrub Koko Loko #7 17 $17.99 $305.83 Shrub Peach Drift […]
Accounting Chapter 2 Inventory List Cost Type Location American Cabernet
Wine Depot Inventory List Location Type Winery Price Size Vintage SKU Quantity Value American Cabernet Sauvignon Beringer 80$ 750 2010 15347 7 560$ American Cabernet Sauvignon Woodward 65$ 750 2012 17539 3 195$ American Chardonnay Babcock 24$ 750 2014 17521 […]
Accounting Chapter 2 Kelly’s Boutique Inc Book List Dept Adult
1 2 3 4 5 6 7 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 Adult Horse Whisperer Evans 2 24.95 22.95 Children Lentil McCloskey 2 16.99 15.63 Children Make Way for Ducklings […]
Accounting Chapter 2 Retained earnings Long-term debt Advertising expense
1 2 3 4 5 6 7 15 16 17 18 19 20 21 22 23 24 25 26 27 Sales revenue 550,000.00 Cost of goods sold 345,000.00 Advertising expense 15,000.00 Depreciation expense 5,000.00 Other expense 4,000.00 Payroll expense 72,000.00 […]
Accounting Chapter 2 Shop Inventory List Category Complete
Snick’s Board Shop Inventory List Category Manufacturer Product Name Price Style Product # Quantity Retail Value Complete Krooked Krooked Eyes Complete 95.99$ Pink/Blue 65-01400 10 959.90$ Complete Element Element Section Complete 89.99$ Black/Red 65-00358 10 899.90$ Complete Almost Almost Mullen […]
Accounting Chapter 2 Cost Markup Price Discount Net Price Quantity
Summary 3/6/2023 1 2 3 4 5 6 A B C D E F What SUP, Inc. Badfish SUP Sales Summary Product 5-Nov 12-Nov 19-Nov 26-Nov Total River Surfer 6’11” 2,700.00 5,670.00 3,420.00 2,295.00 14,085.00 ch2-02_student_name.xlsx 7 8 9 10 […]
Accounting Chapter 2 Fanatic All wave Fanatic Fly Air Inflatable
1 2 3 4 5 6 7 A B C D E F G H What SUP, Inc. Discount % 8% Fanatic SUP Sales Week of November 5, 2018 Product Cost Markup Price Discount Net Price Quantity Total Fanatic Prowave […]
Accounting Chapter 20 A loan amortization schedule breaks down each
21 | P a g e 22 | P a g e 23 | P a g e 24 | P a g e 25 | P a g e 26 | P a g e 27 | P a […]
Accounting Chapter 20 Access Window The Quick Access Toolbar Designed
together. Commands – A command is a button, a box to enter information, or a menu. The principal commands in Access are gathered on the first tab, the Home tab. The commands on this tab are those that Microsoft has […]
Accounting Chapter 20 Each Represents Core Tasks You Excel Groups
8. In Page Layout view there are page margins at the top, sides, and bottom of the worksheet, and a bit of blue space between worksheets. Rulers at the top and side help you adjust margins. 9. Press the F1 […]
Accounting Chapter 20 Financing Activities Usually Involve Borrowings Repayment
1 | P a g e CHAPTER 6 CASH BUDGETING CHAPTER 6 QUESTIONS 1. You should place most of your assumptions that you might consider changing at a later date in a special section of the worksheet called Assumptions. That […]
Accounting Chapter 20 Goal Seeking Allows You Set The Location
1 | P a g e CHAPTER 5 LOAN AND BOND AMORTIZATION CHAPTER 5 QUESTIONS 1. A loan usually involves some constant periodic payment which pays for both interest and principle over some specified period of time. A bond involves […]
Accounting Chapter 20 Layout Tab The Analysis Group Click Trendline
users select Add Chart Element in the Charts Layout group and then Trendlines and Linear Trendlines.) 8. In the percent of sales method, you multiply an estimated uncollectible accounts percentage times sale to determine uncollectible accounts expense. That amount is […]
Accounting Chapter 20 Liquidity Ratios Represent The Ability The Company
CHAPTER 3 FINANCIAL STATEMENT ANALYSIS CHAPTER 3 QUESTIONS 1. Another term for vertical analysis is component analysis. 2. The base amount used for vertical analysis on the income statement is sales revenue. 3. The base amount used for vertical analysis […]
Accounting Chapter 20 Parentheses Specify The Order Calculation Formula The
copy and paste commands or by using AutoFill, that part of the formula designated as an absolute reference would not change. 12. The cell reference C6 is changed to an absolute reference by placing a $ in front of both […]
Accounting Chapter 20 Series Values Text Box Select The Range
1 | P a g e CHAPTER 4 DEPRECIATION CHAPTER 4 QUESTIONS 1. The SLN function will calculate depreciation on a straight-line basis. 2. The SLN function takes 3 arguments: cost, salvage value, and useful life. 3. The arguments to […]
Accounting Chapter 20 The FV function takes very similar arguments
d. 16 | P a g e 17 | P a g e 18 | P a g e 3. Snick’s Board Shop a. 19 | P a g e b. 20 | P a g e c. 21 | […]
Accounting Chapter 20 The operating cash receipts portion of the cash budget
b. c. 14 | P a g e 15 | P a g e d. e. 16 | P a g e 17 | P a g e 3. Snick’s Board Shop a. 18 | P a g e 19 […]
Accounting Chapter 20 The PMT function takes three arguments
35 | P a g e 36 | P a g e 37 | P a g e 38 | P a g e 39 | P a g e 5. Rosey’s Roses 40 | P a g e 41 […]
Accounting Chapter 20 The Reports Wizards Asks Questions What Fields
3. The relationship tool on the Database Tools tab on the ribbon. 4. Queries are essentially questions of the information provided in the database such as: What products do we sell? From whom do we buy products? etc. 5. In […]
Accounting Chapter 3 Accumulated Depreciation Property, Plant, and Equipment
12/31/18 12/31/19 % Change Sales Revenue 850,511.65$ 925,614.50$ 9% Less: Cost of Goods Sold 442,619.87 489,547.25 11% Gross Margin 407,891.78 436,067.25 7% Expenses: Advertising 20,654.21 25,124.88 22% What SUP, Inc. Income Statement For the Year Ended Student Name 3/6/2023 ch3-01_Horizontal_Analysis_student_name.xlsx […]
Accounting Chapter 3 Buildings Equipment Less Accumulated Depreciation Total Liabilities
% of Sales % of Sales % Change Sales 200,000$ 100% 225,000$ 100% 13% Less: Cost of Goods Sold 85,000 43% 100,000 44% 18% Gross Margin 115,000 58% 125,000 56% 9% Expenses: Advertising 18,000$ 9% 17,000$ 8% -6% Rosey’s Roses […]
Accounting Chapter 3 Cost of Goods Sold Net income before taxes
12/31/18 % 12/31/19 % Sales Revenue 850,511.65$ 100% 925,614.50$ 100% Less: Cost of Goods Sold 442,619.87 52% 489,547.25 53% Gross Margin 407,891.78 48% 436,067.25 47% Expenses: Advertising 20,654.21 2% 25,124.88 3% What SUP, Inc. Income Statement For the Year Ended […]
Accounting Chapter 3 Current Liabilities Accounts Payable Payroll Liabilities Notes
12/31/18 12/31/19 % of Sales % Change Sales Revenue 850,000.00$ 950,000.00$ 100% 12% Less: Cost of Goods Sold 445,000.00 500,000.00 53% 12% Gross Margin 405,000.00 450,000.00 47% 11% Expenses: Advertising 18,000.00 30,000.00 3% 67% What SUP, Inc. Income Statement For […]
Accounting Chapter 3 Equity Liabilities Current Liabilities Accounts Payable Income
31-Dec-18 31-Dec-19 % of Sales % Change Sales Revenue 345,274.22$ 400,000.00$ 100% 16% Less: Cost of Goods Sold 164,217.74 210,000.00 53% 28% Gross Margin 181,056.48 190,000.00 48% 5% Expenses: Advertising 25,871.45$ 28,000.00$ 7% 8% Kelly’s Boutique Income Statement For the […]
Accounting Chapter 3 Less Accumulated Depreciation Total Liabilities And Stockholders
% Sales % Sales % Change Sales 45,000$ 100% 35,000$ 100% -22% Less: Cost of Goods Sold 14,000 31% 16,000 46% 14% Gross Margin 31,000 69% 19,000 54% -39% Expenses: Snick’s Board Shop Income Statement for the period ended 12/31/2018 […]
Accounting Chapter 3 Liabilities And Stockholders Equity Liabilities Current Liabilities
12/31/19 12/31/20 % of Sales % Change Sales Revenue 950,000.00$ 1,300,000.00$ 100% 37% Less: Cost of Goods Sold 500,000.00 800,000.00 62% 60% Gross Margin 450,000.00 500,000.00 38% 11% Expenses: What SUP, Inc. Income Statement For the Year Ended 6% 5% […]
Accounting Chapter 3 Liabilities and Stockholders’ Equity Payroll Liabilities
12/31/18 12/31/19 % Change Sales Revenue 850,511.65$ 925,614.50$ 9% Less: Cost of Goods Sold 442,619.87 489,547.25 11% Gross Margin 407,891.78 436,067.25 7% Expenses: Advertising 20,654.21 25,124.88 22% What SUP, Inc. Income Statement For the Year Ended – 20,000.00 40,000.00 60,000.00 […]
Accounting Chapter 3 Current ratio Quick ratio Receivable turnover
Profitability Return on owners’ investment 45% Return on total investment 23% Profit margin 14% What SUP, Inc. Ratio Analysis Dec-2019 Gross margin 47% Liquidity Current ratio 4.04 Quick ratio 1.65 Receivable turnover 10.96 Inventory turnover 3.53 Solvency Debt-to-equity 111% Liability […]
Accounting Chapter 3 Marketing Depreciation Interest Salary Wages Supplies
% Sales % Sales % Change Sales 375,000$ 100% 425,000$ 100% 13% Less: Cost of Goods Sold 150,000 40% 191,250 45% 28% Gross Margin 225,000 60% 233,750 55% 4% Expenses: Advertising 8,000$ 2% 18,250$ 4% 128% Wine Depot, Inc. Income […]
Accounting Chapter 4 Asset 1001 Depreciation Comparison 1000
6000 8000 10000 Asset 1001 Depreciation Comparison 0 2000 4000 2014 2015 2016 2017 2018 SL DDB SYD
Accounting Chapter 4 Chairs Total Student Name Salvage value
What SUP, Inc. Equipment Depreciation Summary Asset Date Acquired Cost Deprec. Method 2017 Deprec. 2017 Acc. Deprec. 2018 Deprec. 2018 Acc. Deprec. 2019 Deprec. 2019 Acc. Deprec. Display Racks 1/1/2017 25,000$ SYD $8,333 $8,333 $6,667 $15,000 $5,000 $20,000 Student Name […]
Accounting Chapter 4 Computer System Depreciation Comparison
8000 10000 Asset 1001 Depreciation Comparison 0 2000 4000 6000 2017 2018 2019 2020 2021 SL DDB SYD 4000 Asset 1002 Depreciation Comparison 0 1000 2000 3000 2017 2018 2019 2020 2021 SL DDB SYD 50000 60000 Asset 1003 Depreciation […]
Accounting Chapter 4 Cost Method Equipment Depreciation Summary Asset
What SUP, Inc. Equipment Depreciation Summary Asset Date Acquired Cost Deprec. Method 2017 Deprec. 2017 Acc. Deprec. 2018 Deprec. 2018 Acc. Deprec. 2019 Deprec. 2019 Acc. Deprec. 2020 Deprec. 2020 Acc. Deprec. 2021 Deprec. 2021 Acc. Deprec. Display Racks 4/1/2017 […]
Accounting Chapter 4 Days in 1st year Depreciation method Asset
What SUP, Inc. Equipment Depreciation Summary Asset Date Acquired Cost Deprec. Method 2017 Deprec. 2017 Acc. Deprec. 2018 Deprec. 2018 Acc. Deprec. 2019 Deprec. 2019 Acc. Deprec. 2020 Deprec. 2020 Acc. Deprec. 2021 Deprec. 2021 Acc. Deprec. Student Name 3/6/2023 […]
Accounting Chapter 4 Depreciation Comparison Estimated useful life
4000 6000 8000 10000 Asset 1001 Depreciation Comparison 0 2000 2017 2018 2019 2020 2021 SL DDB SYD 3000 4000 Asset 1002 Depreciation Comparison 0 1000 2000 2017 2018 2019 2020 2021 SL DDB SYD
Accounting Chapter 4 Depreciation Schedule Estimated useful life
What SUP, Inc. Equipment Depreciation Summary Asset Date Acquired Cost Deprec. Method 2017 Deprec. 2017 Acc. Deprec. 2018 Deprec. 2018 Acc. Deprec. 2019 Deprec. 2019 Acc. Deprec. 2020 Deprec. 2020 Acc. Deprec. 2021 Deprec. 2021 Acc. Deprec. Display Racks 1/1/2017 […]
Accounting Chapter 4 Partial Year Schedule Depreciation method
What SUP, Inc. Depreciation Schedule Asset # 1004 Asset Table Date acquired 8/1/2017 Cost 95,000.00$ Year Depreciation Expense Accumulated Depreciation Straight-Line Test Switch Depreciation Expense Accumulated Depreciation 2017 $19,000.00 $19,000.00 $9,300.00 – $19,000.00 $19,000.00 2018 $15,200.00 $34,200.00 $8,222.22 – $15,200.00 […]
Accounting Chapter 4 Partial Year Schedule Depreciation Expense
What SUP, Inc. Equipment Depreciation Summary Asset Date Acquired Cost Deprec. Method 2017 Deprec. 2017 Acc. Deprec. 2018 Deprec. 2018 Acc. Deprec. 2019 Deprec. 2019 Acc. Deprec. 2020 Deprec. 2020 Acc. Deprec. 2021 Deprec. 2021 Acc. Deprec. Display Racks 1/1/2017 […]
Accounting Chapter 4 Rosey’s Roses Depreciation Schedule Date acquired
Rosey’s Roses Depreciation Schedule Asset Building #1 Date acquired 1/1/2018 Year Depreciation Expense Accumulated Depreciation 2018 $4,666.67 $4,666.67 2019 $4,666.67 $9,333.33 2020 $4,666.67 $14,000.00 2021 $4,666.67 $18,666.67 2022 $4,666.67 $23,333.33 2023 $4,666.67 $28,000.00 2024 $4,666.67 $32,666.67 2025 $4,666.67 $37,333.33 2026 […]
Accounting Chapter 4 Student Name Depreciation Schedule Salvage value
What SUP, Inc. Equipment Depreciation Summary Asset Date Acquired Cost Deprec. Method 2014 Deprec. 2014 Acc. Deprec. 2015 Deprec. 2015 Acc. Deprec. 2016 Deprec. 2016 Acc. Deprec. Display Racks 1/1/2014 25,000$ SYD $8,333 $8,333 $6,667 $15,000 $5,000 $20,000 Student Name […]
Accounting Chapter 4 What Sup Inc Depreciation Schedule Asset
What SUP, Inc. Equipment Depreciation Summary Asset Date Acquired Cost Deprec. Method 2017 Deprec. 2017 Acc. Deprec. 2018 Deprec. 2018 Acc. Deprec. 2019 Deprec. 2019 Acc. Deprec. Display Racks 1/1/2017 25,000$ DDB $10,000 $10,000 $6,000 $16,000 $3,600 $19,600 Student Name […]
Accounting Chapter 4 Acquired Asset Cost Method Depreciation method
What SUP, Inc. Equipment Depreciation Summary Asset Date Acquired Cost Deprec. Method 2014 Deprec. 2014 Acc. Deprec. 2015 Deprec. 2015 Acc. Deprec. 2016 Deprec. 2013 Acc. Deprec. Display Racks 1/1/2014 25,000$ DDB $10,000 $10,000 $6,000 $16,000 $3,600 $19,600 Student Name […]
Accounting Chapter 4 Acquired Method Display Racks Depreciation Schedule
What SUP, Inc. Equipment Depreciation Summary Asset Date Acquired Cost Deprec. Method 2014 Deprec. 2014 Acc. Deprec. 2015 Deprec. 2015 Acc. Deprec. 2016 Deprec. 2016 Acc. Deprec. Display Racks 1/1/2014 25,000$ S/L $5,000 $5,000 $5,000 $10,000 $5,000 $15,000 Student Name […]
Accounting Chapter 4 Asset Date acquired Cost Depreciation method
What SUP, Inc. Equipment Depreciation Summary Asset Date Acquired Cost Deprec. Method 2017 Deprec. 2017 Acc. Deprec. 2018 Deprec. 2018 Acc. Deprec. 2019 Deprec. 2019 Acc. Deprec. 2020 Deprec. 2020 Acc. Deprec. 2021 Deprec. 2021 Acc. Deprec. Student Name 3/6/2023 […]
Accounting Chapter 4 Depreciation method Salvage value Estimated useful life
What SUP, Inc. Equipment Depreciation Summary Asset Date Acquired Cost Deprec. Method 2017 Deprec. 2017 Acc. Deprec. 2018 Deprec. 2018 Acc. Deprec. 2019 Deprec. 2019 Acc. Deprec. 2020 Deprec. 2020 Acc. Deprec. 2021 Deprec. 2021 Acc. Deprec. Display Racks 1/1/2017 […]
Accounting Chapter 4 Full Year Depreciation Expense Depreciation Schedule
What SUP, Inc. Equipment Depreciation Summary Asset Date Acquired Cost Deprec. Method 2014 Deprec. 2014 Acc. Deprec. 2015 Deprec. 2015 Acc. Deprec. 2016 Deprec. 2016 Acc. Deprec. Total –$ $0 $0 $0 $0 $0 $0 Student Name 3/6/2023 ch4-07_student_name.xlsx What […]
Accounting Chapter 4 Kelly’s Boutique Depreciation Summary Date
Kelly’s Boutique Depreciation Summary Asset Date Acquired Cost Deprec. Method 2015 Deprec. 2015 Acc. Deprec. 2016 Deprec. 2016 Acc. Deprec. 2017 Deprec. 2017Acc. Deprec. 2018 Deprec. 2018 Acc. Deprec. Student Name 3/6/2023 ch4-03_student_name.xlsx Building 1/1/2015 625,000$ S/L $24,000 $24,000 $24,000 […]
Accounting Chapter 4 Partial days in first year Cost Depreciation method
What SUP, Inc. Equipment Depreciation Summary Asset Date Acquired Cost Deprec. Method 2017 Deprec. 2017 Acc. Deprec. 2018 Deprec. 2018 Acc. Deprec. 2019 Deprec. 2019 Acc. Deprec. 2020 Deprec. 2020 Acc. Deprec. 2021 Deprec. 2021 Acc. Deprec. Student Name 3/6/2023 […]
Accounting Chapter 4 Salvage value Estimated useful life Days in 1st year
What SUP, Inc. Equipment Depreciation Summary Asset Date Acquired Cost Deprec. Method 2017 Deprec. 2017 Acc. Deprec. 2018 Deprec. 2018 Acc. Deprec. 2019 Deprec. 2019 Acc. Deprec. 2020 Deprec. 2020 Acc. Deprec. 2021 Deprec. 2021 Acc. Deprec. Display Racks 6/1/2017 […]
Accounting Chapter 4 Snick’s Board Shop Depreciation Schedule Asset
Snick’s Board Shop Depreciation Schedule Asset Shelving Date acquired 1/1/2016 Year Depreciation Expense Accumulated Depreciation 2016 $750.00 $750.00 2017 $750.00 $1,500.00 2018 $750.00 $2,250.00 2019 $750.00 $3,000.00 2020 $750.00 $3,750.00 2021 $750.00 $4,500.00 2022 $750.00 $5,250.00 2023 $750.00 $6,000.00 2024 […]
Accounting Chapter 4 Wine Depot Depreciation Summary Salvage value
Wine Depot Depreciation Summary Asset Date Acquired Cost Deprec. Method 2015 Deprec. 2015 Acc. Deprec. 2016 Deprec. 2016 Acc. Deprec. 2017 Deprec. 2017 Acc. Deprec. 2018 Deprec. 2018 Acc. Deprec. Student Name 3/6/2023 ch4-04_student_name.xlsx Equipment 1/1/2015 689,115$ S/L $134,823 $134,823 […]
Accounting Chapter 5 Changing cells for each scenario are highlighted
Scenario Summary Current Values: Best Case Worst Case Changing Cells: Rate 3.00% 2.80% 3.20% Loan_Amount 425,000.00$ 450,000.00$ 400,000.00$ Result Cells: Payment 92,800.69$ 97,699.13$ 87,841.20$ Total_Payments 464,003.46$ 488,495.67$ 439,206.02$ Total_Interest 39,003.46$ 38,495.67$ 39,206.02$ Notes: Current Values column represents values of changing […]
Accounting Chapter 5 Current Values column represents values of changing
Scenario Summary Current Values: 1 2 3 4 Changing Cells: Market_Rate 11.00% 12.00% 10.00% 9.00% 8.00% Result Cells: Proceeds $96,304.10 $92,790.45 $100,000.00 $103,889.65 $107,985.42 Total_Interest_Expense $53,695.90 $57,209.55 $50,000.00 $46,110.35 $42,014.58 Notes: Current Values column represents values of changing cells at […]
Accounting Chapter 5 Interest Payment Interest Expense Amortization Discount Premium
Scenario Summary Current Values: 1 2 3 4 Changing Cells: Stated_Rate 4.00% 3.00% 3.50% 4.50% 6.00% Result Cells: Interest_Payment $100,000.00 $75,000.00 $87,500.00 $112,500.00 $150,000.00 Proceeds $2,306,956.63 $2,113,913.25 $2,210,434.94 $2,403,478.31 $2,693,043.37 Notes: Current Values column represents values of changing cells at […]
Accounting Chapter 5 Notes Current Values Column Represents Values Changing
Scenario Summary Current Values: Best Case Worst Case Changing Cells: Rate 6.00% 5.00% 7.00% Loan_Amount 65,000.00$ 75,000.00$ 60,000.00$ Result Cells: Payment $2,880.84 $3,290.35 $2,686.35 Total_Payments 69,140.15$ 78,968.50$ 64,472.51$ Total_Interest 4,140.15$ 3,968.50$ 4,472.51$ Notes: Current Values column represents values of changing […]
Accounting Chapter 5 Best Case Worst Case Changing Cells
Scenario Summary Current Values: Best Case Worst Case Changing Cells: Loan_Amount 100,000.00$ 125,000.00$ 90,000.00$ Rate 10.00% 9.00% 11.00% Result Cells: Payment $16,274.54 $19,477.51 $15,282.13 Total_Payments 162,745.39$ 194,775.11$ 152,821.28$ Total_Interest 62,745.39$ 69,775.11$ 62,821.28$ Notes: Current Values column represents values of changing […]
Accounting Chapter 5 Changing Cells Rate Result Cells Payment
Scenario Summary Current Values: 1 2 3 4 Changing Cells: Rate 5% 10% 9% 7% 6% Result Cells: Payment $146,896.85 $174,594.67 $168,886.94 $157,720.24 $152,264.44 Notes: Current Values column represents values of changing cells at time Scenario Summary Report was created. […]
Accounting Chapter 5 Loan Amortization Schedule Amount Rate Term
What SUP, Inc. Loan Amortization Schedule Amount 75,000.00$ Rate 10% Term 3 Payment $30,158.61 Payment # Payment Interest Principal Balance Student Name 3/6/2023 ch5-01_student_name.xlsx 75,000.00$ 1 $30,158.61 7,500.00$ $22,658.61 52,341.39$ 2 $30,158.61 5,234.14$ $24,924.47 27,416.92$ 3 $30,158.61 2,741.69$ $27,416.92 (0.00)$ […]
Accounting Chapter 5 Scenario Summary Current Values Best Case
Scenario Summary Current Values: Best Case Worst Case Changing Cells: Rate 3.00% 2.50% 3.50% Loan_Amount 500,000.00$ 550,000.00$ 450,000.00$ Result Cells: Payment $43,725.74 $47,716.58 $39,666.87 Total_Payments 524,708.86$ 572,598.95$ 476,002.46$ Total_Interest 24,708.86$ 22,598.95$ 26,002.46$ Notes: Current Values column represents values of changing […]
Accounting Chapter 6 Cash From To Operating Activities Investing Activities
Kelly’s Boutique Cash Budget 1st Qtr. 2nd Qtr. 3rd Qtr. 4th Qtr. Year Operating activities Operating cash receipts Product sales revenue 40,000 40,800 41,616 42,448 164,864 Collections in the quarter of sale 32,000 32,640 33,293 33,959 131,891 Collections in the […]
Accounting Chapter 6 Expenses Advertising Expense Marketing Expense Wages Expense
Wine Depot Cash Budget Year 1 Year 2 Year 3 Year 4 Operating activities Operating cash receipts Product sales revenue 650,000 715,000 786,500 865,150 Collections in the year of sale 598,000 657,800 723,580 795,938 Collections in the year following sale […]
Accounting Chapter 6 General and administrative expenses Selling expenses
What SUP Operating Cash Payments Budget Jan Feb Mar Total Operating cash payments Product sales revenue 150,000 165,000 175,000 490,000 Purchases Cost of expected sales 90,000 99,000 105,000 294,000 Required ending inventory 49,500 52,500 54,000 54,000 Assumptions Beginning inventory 75,000 […]
Accounting Chapter 6 Professional Services Revenue Product Sales Revenue Interest
What SUP Operating Cash Receipts Budget Jan Feb Mar Total Operating cash receipts Estimated repair hours 800 900 950 2,650 Professional services revenue 64,000 72,000 76,000 212,000 Assumptions Pct. collections in current month 70% Pct. collections in 1st subsequent month […]
Accounting Chapter 6 Snicks Board Shop Cash Budget Operating Activities
Wages expense 56,000 60,480 65,318 70,544 Supplies expense 450 486 525 567 Utilities expense 1,600 1,728 1,866 2,016 Expenses 60,550 80,394 85,626 91,276 Operating cash payments 212,550 207,050 213,747 223,194 Cash from (to) operating activities 77,450 101,050 103,596 103,669 Loan […]
Accounting Chapter 6 Subsequent Quarter Collections Operating Cash Receipts Operating
What SUP 1st 2nd 3rd 4th Cash Budget Quarter Quarter Quarter Quarter Year Operating activities Operating cash receipts Estimated repair hours 1,500 1,600 1,700 1,800 6,600 Professional services revenue 75,000 80,000 85,000 90,000 330,000 Purchases Cost of expected sales 255,000 […]
Accounting Chapter 6 Financing activities Loan proceeds Loan payments
Interest expense – 4,000 4,000 4,000 Wages expense 20,000 21,000 22,050 23,153 Supplies expense 1,000 1,050 1,103 1,158 Utilities expense 3,300 3,465 3,638 3,820 Expenses 39,300 45,265 47,328 49,495 Operating cash payments 239,300 251,312 297,917 339,383 Cash from (to) operating […]
Accounting Chapter 7 Accounts Receivable Balance End Past Experience Ratio
Kelly’s Boutique Ch 7-06 Solution Allowance for Uncollectible Accounts Aging Method Information Amount Past experience ratio Current 600,000$ 4.00% 0 – 30 Days Past Due 39,000$ 8.00% Past experience ratio for % of sales method 0.80% Facts: Accounts receivable balance […]
Accounting Chapter 7 Delivery Expense When Least Squares Regression Method
Rosey’s Roses Present and Future Values Future need: 15,000.00$ Future need: 15,000.00$ Term (in years): 4 Term (in years): 4 Interest rate: 2% Interest rate: 2% Annuity payment required: ($3,639.36) Invest now: ($13,857.68) Year Interest Annuity Investment Year Interest Investment […]
Accounting Chapter 7 Interest Rate Term In Years Investment Value
What SUP Ch 07-01 Solution Present Value Analysis Year Interest Annuity Investment Future need: 95,000.00$ 0 $0.00 Term (in years): 4 1 $0.00 $22,371.55 $22,371.55 Interest rate: 4% 2 $894.86 $22,371.55 $45,637.97 Annuity payment required: ($22,371.55) 3 $1,825.52 $22,371.55 $69,835.04 […]
Accounting Chapter 7 Least Squares Regression Method Variable Cost employee Fixed
Kelly’s Boutique Month Employees Payroll Ch 07-05 Solution Jan 8 33,000 Predicting Costs Feb 12 60,000 Mar 11 54,000 Apr 14 47,000 May 17 78,000 Hi-Lo Method Variable cost/employee 3,656.25$ Fixed cost 3,750.00$ Prediction of expense with 43 employees = […]
Accounting Chapter 7 Least Squares Regression Method Variable Cost hour Open
What SUP Quarter Hours Open Expense Ch 07-02 Solution 1st 1200 16,000 High Expense 1800 22,000 Low Expense 1200 16,000 Difference 600 6,000 Prediction of expense if open 2,000 hours = Hi-Lo Method 24,000$ Variable cost/hour open 10.00$ Fixed cost […]
Accounting Chapter 7 Least Squares Regression Method Variable Cost unit Sold
Wine Depot Month Units Sold Selling Expense Ch 07-08 Solution Jan 10,000 28,000$ Predicting Costs Feb 12,000 36,000$ Mar 18,500 50,000$ Least Squares / Regression Method Variable cost/unit sold 1.88$ Fixed cost 6,385.38$ Prediction of selling expense with 19,000 units […]
Accounting Chapter 7 Percentage Sales Method Allowance For Uncollectible Accounts
What SUP Ch 7-03 Solution Current 0 – 30 Days Past Due 31 – 60 Days Past Due 61 – 90 Days Past Due > 90 Days Past Due Allowance for Uncollectible Accounts 700,000 120,000 80,000 30,000 10,000 5.00% 8.00% […]
Accounting Chapter 7 Prediction of utility expense when open
Snick’s Board Shop Month Hours Open Utility Expense Ch 07-11 Solution Jan 200 3,000$ Predicting Costs Feb 190 3,100$ Mar 185 2,700$ Apr 140 2,600$ Hi-Lo Method Variable cost/unit sold 16.00$ Fixed cost 360.00$ Prediction of utility expense when open […]
Accounting Chapter 7 Collections on account Write-offs of accounts receivable
Wine Depot Ch 7-09 Solution Allowance for Uncollectible Accounts Past experience ratio for % of sales method 2.10% Aging Method Information Amount Past experience ratio Current 734,539$ 3.00% Facts: Accounts receivable balance (beg) 758,271 Sales on account 1,601,542 Collections on […]
Accounting Chapter 7 Invest now Future need Interest rate Term
Snick’s Board Shop Ch 07-10 Solution Present Value Analysis Annuity payment required: ($14,770.17) Year Interest Annuity Investment 0 $0.00 Future need: 80,000.00$ 1 $0.00 $14,770.17 $14,770.17 Investment value in future: $89,423.99 Year Interest Investment 0 $73,500.00 Current investment: ($73,500.00) 1 […]
Accounting Chapter 7 Investment value in future Term Current investment
Wine Depot Ch 07-07 Solution Present Value Analysis Annuity payment required: ($11,093.04) Year Interest Annuity Investment 0 $0.00 Term (in years): 7 1 $0.00 $11,093.04 $11,093.04 Interest rate: 3% 2 $332.79 $11,093.04 $22,518.87 Investment value in future: $9,838.99 Year Interest […]
Accounting Chapter 7 Present Value Analysis Annuity payment required
Kelly’s Boutique Ch 07-04 Solution Present Value Analysis Annuity payment required: ($11,925.69) Year Interest Annuity Investment 0 $0.00 Future need: 150,000.00$ 1 $0.00 $11,925.69 $11,925.69 Term (in years): 10 2 $596.28 $11,925.69 $24,447.66 10 $6,574.97 $11,925.69 $150,000.00 Investment value in […]
Accounting Chapter 7 Sales on account Collections on account
Snick’s Board Shop Ch 7-12 Solution Allowance for Uncollectible Accounts Aging Method Information Amount Past experience ratio Current 2,400$ 2.00% Total 3,700$ Facts: Accounts receivable balance (beg) 5,000 Sales on account 45,000 Collections on account (45,500) Write-offs of accounts receivable […]