Excel Applications for Accounting Principles
4th Edition
ISBN: 9781111581565
Author: Gaylord N. Smith
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 18, Problem 2R
Open the file CVP from the website for this book at cengagebrain.com. Enter the formulas where indicated on the worksheet. Enter your name in cell A1. Save the solution as CVP2 and print the worksheet. Also print your formulas. Check figures: Break-even point in sales dollars (cell C35), $1,616,000; Net income (cell C38), $95,000.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
DO TYPEWRITTEN AND FOLLOW INSTRUCTIONS FOR UPVOTE
Please see below.
finance
Chapter 18 Solutions
Excel Applications for Accounting Principles
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
- I need help answering the questions below... 1. Using the assumptions provided in Excel Spreadsheet, what is the total number of customers generated from this advertising? 2. If Dr. Corneal’s customers spend $300 on average, what is the total revenue generated from this advertising? 3. The cost to purchase the advertising is as follows: Google Ads: $5,000 Newspapers: $3,000 Magazines: $6,000 Radio: $1,000 Calculate the overall ROI and the ROI per advertising source. How do these number help you plan your advertising budget going forward? To answer this question, define ROI, explain how ROI is used (see your book), apply the numbers you have calculated and show how you would use these numbers for planning purposes. Note - ROI is expressed as a percent. ROI= (Revenue - Costs)/Costsarrow_forwardCreate a chart that would show the fluctuation of revenue throughout the month. Put a note in the worksheet stating which day of the month has the highest sale show the solution using excelarrow_forwardFind the monthly revenue 1 month and 4 months after the online store opened. Record the value in the table. Round to the nearest whole dollar.arrow_forward
- an online retailer selling tennis supplies. HST is calculated by the web software for every sale at a rate of 13%. Sales (before tax) for the last month was $125,000. All sales are on debit card or bank credit card. Cost of goods sold is 75% of sales and a perpetual inventory system is used. This information needs to be entered into the accounting system. Instructions (a) Calculate the amount of HST. (b) Prepare the journal entry to record the sales, sales taxes, and cost of goods sold. (c) Record the journal entry to record sending the collected HST to the government.arrow_forwardramon hernandez saw the following advertisement for a used volkswagen bug and decided to work out the numbers to be sure the ad had no errors. cash price $7,880 down payment $0 annual percentage rate 14.53% deferred price $11,131.80 or 60 payments at $185.53 per month a. calculate the amount financed: b. calculate the finance charge. (round your answer to the nearest cent.): c. calculate the apr by table lookup. (use table 14.1(b).) (round your answers to 2 decimal places.): d. calculate the monthly payment by formula. (round your answer to the nearest cent.): Calculate the monthly payment by table lookup at 14.50% (Use table 14.2 round your answer to the nearest cent):arrow_forwardPlease please answer all three subparts. I will really upvote. Thanksarrow_forward
- A delivery driver received a paycheck for $1360. The company pays $5 for each pick-up at the restaurant and $3 for each drop-off. The number of drop-offs was four times the number of pick-ups Let x be the number of pick-ups and y the number of drop-offs. Answer parts (a) through (c). Use systems of equations to work this applied problem SED (a) Write an equation that represents the total amount of the paycheck. The equation represents the total amount of the paycheck (Type your answer in general form.) (b) Write an equation that represents the relationship between the number of pick-ups and the number of drop-offs The equation represents the relationship between the number of pick-ups and the number of drop-offs (Type your answer in general form.) (c) Find the number of pick-ups and the number of drop-offs The number of pick-ups is x The number of drop-offs is yarrow_forwardPLEASE MAKE IT IN EXCEL AND SHOW THE FORMULAS (Take screenshots) La Resolana, S.A., has credit sales of $180,000 per year, with net payment terms of 30 days, which is also the average collection period. La Resolana does not currently offer any cash discounts, so customers take the 30 days to pay. What is the average accounts receivable balance? What is the accounts receivable turnover?arrow_forwardYou have a credit card with an APR of 15%. You begin with a balance of $800. In the first month you make a payment of $300 and you make charges amounting to $100. In the second month you make a payment of $200 and you make new charges of $500. Determine all values in the given table. (Enter all answers to the nearest cent.) Month 1 Month 2 Previous Balance mil m21 Payments m12 m22 Purchases m13 M23 Finance Charge m14 m24 New Balance m15 m25arrow_forward
- Based on the provided information in the attached image, please calculate the following simpe equations; (It's super simple, just tiny simple mathematical calculations that should take only 2 minutes, I'm just lost with the wording...) Average collection period, = Days to sell inventory, = Accounts payable payment period, = Amborse's cash-to-cash cycle, = The company's bank loan =arrow_forwardYou have a credit card with an APR of 22.8%. You begin with a balance of $1500, in response to which you make a payment of $250. The first month you make charges amounting to $550. You make a payment of $250 to reduce the new balance, and the second month you charge $650. Complete the following table. (Round your answers to the nearest cent.) Previous balance Payments Purchases Finance charge New balance Month 1 $1500 $ $ $ $ Month 2 $ $ $ $ $arrow_forwardRESOLVE THIS PROBLEM IN DIGITAL FORMAT (NOT HANDWRITTEN) Solve the following problem step by step, include the formulas you use and the development pleasearrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage Learning
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
Cost-Volume-Profit (CVP) Analysis and Break-Even Analysis Step-by-Step, by Mike Werner; Author: Accounting Step by Step;https://www.youtube.com/watch?v=D0MOfse9OWk;License: Standard Youtube License