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
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 solutionStudents have asked these similar questions
ramon 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: $7,880
b. calculate the finance charge. (round your answer to the nearest cent.): $3,251.80
c. calculate the apr by table lookup. (use table 14.1(b).) (round your answers to 2 decimal places.): 14.50% to 14.75%
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): ??
A new book publishing and sales project estimates that the first year 7,000 printed units and 2,000 digital units will be sold.The printer will charge them $5 for each book.The publisher will sell the books for $12 each.The virtual books will be sold for $6 through a platform and the publisher receives $3.The authors of the books receive 5% of the sales made by the publisher, whether online or in print, which is recorded as an expense.
The market study suggests that sales of printed books can increase at 20% per year and those of digital format at 30% per year.The initial equipment will be reduced, since they work with the subcontracting of printed material. Basically, they include computer equipment, software and furniture that have a value of 20,000; In addition, a vehicle will be purchased for a value of 15,000. Computer equipment, software and furniture are depreciated instraight line in 5 years. In year 6, these equipments must be bought again for the same value.The vehicle is…
Eastman Publishing Company is considering publishing an electronic textbook about spreadsheet applications for business. The fixed cost of manuscript preparation, textbook design, and website construction is estimated to be $160,000. Variable processing costs are estimated to be $6.00 per book. The publisher plans to sell single-user access to the book for $46.
a. Build a spreadsheet model to calculate the profit/loss for a given demand. For example, what profit can be anticipated with a demand of 3500 copies?
b. Use a data table to very demand from 1000 to 6000 in increments of 200 to assess the sensitivity of profit to demand.
c. Use Goal Seek to determine the access price per copy that the publisher must charge to break even with the demand of 3500 copies. Before you move on to Problem 2, make sure you save your workbook with this value displayed or else you will not receive credit.
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
- ABC operates a consignment shop where she sells clothes for women and children. The average number of consignments sold per month is 1,000. The average material cost and the selling price of each consignment are $8 and $20, respectively. The monthly fixed costs to run this business are given below: Rental cost: $750Utilities: $150Advertising: $35Insurance: $100Labor cost: $4,000 Using Excel spreadsheet / worksheet, determine Anna's profit. Attach excel solution.arrow_forwardPLEASE, PERFORM THE EXERCISE IN EXCEL AND SHOW THE FORMULAS PLEASE, PERFORM THE EXERCISE IN EXCEL AND SHOW THE FORMULASCC2) La Reina de Oriente, S.A., a company that sells sausages, knows that it pays its suppliers 10 times a year. To determine the average collection period it is known that the annual sales of the company were $5'183,220.00, of which 70% are on credit and the average balance of customers is $382,982.37, that is to say it is necessary to calculate the turnover of accounts receivable; and the average age of inventory is based on the inventory turnover, whose data to calculate it as the previous one are: Average inventory 153,192.95 and its annual cost of sales amounts to $1'002,716.78. The company spends about $12.5 million in operating cycle investments. It plans to make modifications to its policies so that it can reduce its PPC by 5 days, and its EPI by one (before converting it to days). Negotiations with your supplier to extend payment terms have not been…arrow_forwardOHaganBooks.com generates revenue through it o'Books e-book service. Author royalties and copyright fees cost the company $5 per novel, and the monthly cost of operating and maintaining the service amounts to $446. The company is currently charging customers $8 per novel. Find the associated cost, revenue, and profit functions and use them to determine how many novels must be sold in order to make a profit. (Hint: If the break-even is where they make no profit, you must round up to make a profit.) To make a profit they must sell at least:arrow_forward
- Using the data from the attached picture, compute for the following: 1. If 5,000 units are sold, what will be the store’s operating income (loss)?2. If sales commissions are discontinued and fixed salaries are raised by a total of₱810,000, what would be the annual breakeven point in (a) units sold and (b) revenues?3. Refer to the original data. If in addition to his fixed salary, the store manager is paida commission of ₱30 per unit in excess of the break-even point, what would be the store’s operating income if 10,000 units were sold.arrow_forwardcan you please explain how to recognize the revenue if you have the information below using IFRS The A company sells copy machine at a sales price of JPY1,500,000 per unit. The salesprice includes delivery and installation. It also gives a maintenance service (6 years) in which atechnician checks to make sure that the machine is working properly with a price of JPY500,000(one-time prepayment).The A company has started a promotion campaign in which the maintenance service (6years) will be offered for free to a client that buys a copy machine of JPY 1,728,000.The A company has made a contract to sell a copy machine with the maintenance service(6 years) to B company by JPY 1,728,000.arrow_forwarda. Assume that the cost of goods sold is 60% and that the monthly discount rate is 1%. Looking at the values in the exhibit above, you note that the average monthly revenue for a subscribed customer rises as the company sends more emails. In addition, the average monthly revenue for an unsubscribed customer also rises as the company sends more emails. What could explain both of these patterns? b. Calculate the 6-month LTV for each of the four tested email frequencies. Please show the spreadsheet with your calculations and be clear about any assumptions you are making. c. Based on this test, how many emails-per-week should the company be sending to its customers? This email frequency should apply to all customers; the company doesn't want to implement a different email frequency for different kinds of peoplearrow_forward
- The Cycle Shoppe has decided to offer credit to its customers during the spring selling season. Sales are expected to be 330 bicycles. The average cost to the shop of a bicycle is $300. The owner knows that only 93 percent of the customers will be able to make their payments. To identify the remaining 7 percent, she is considering subscribing to a credit agency. The initial charge for this service is $540, with an additional charge of $6 per individual report. What is the amount of the net savings from subscribing to the credit agency? A. $3,790 B. $3,920 C. $4,080 D. $4,410 E. $4,950arrow_forwardYou are doing some financial analysis research for your work and managed to get (incomplete) data. You will use this data to deduce the required information. You can assume 365 days in a year. a) Alpha Co. reported a cost of goods sold of $64,380.00 and an accounts payable balance of $16,700.00 last year. Compute the average time taken to pay suppliers. Discuss the significance of a longdays’ costs in payables for the firm. b) Bravo Ltd. equity multiplier is 1.93, its total asset turnover is 2.65, and its profit margin is 4.20 percent. Compute the Return on Equity (ROE). Explain the impact on ROE, should the total asset turnover decline next year. c) Charlie Inc. has a profit margin of 7.90 percent, a total asset turnover of 1.54, and a Return on Equity (ROE) of 13.47 percent. Solve for the debt-equity ratio. d) Delta GMBH’s ROE is 8.9 percent. Sales are $2,956,000.00. Total debt ratio is 0.3743. Total debt is $964,000.00. Determine the return on assets (ROA).arrow_forwardDavid Role is a marketing strategist with Google. He budgets 1/8 of his salary for housing. His annual salary is $135,000. How much should he budget for housing monthly? Input only the number with a comma or decimal if needed. 16,875 is not the answer. Every time I try to work this problem that's the answer I come up with but it's wrong. Please help me. This question is from the portion formula chapter in business math with converting percents to decimals, decimals to percents, etc. Please help me.arrow_forward
- Your Fan retails computer fans in two sizes: small and large. The business has provided you with the following information for a regular month of trading: Small fans Large fans Selling price ($ per fan) 37 60 Purchase price ($ per fan) 26 39 Delivery cost to customer ($ per fan) 1.0 1.5 Monthly fixed cost ($) 20,000 Average monthly sales volume (units) 900 550 Business owners are considering selling computer fans in one size only. Retailing one fan size would mean lower purchase cost and selling price per unit and larger monthly sales volume. The table below reflects how trading would change if only small or large fans were sold. Only small fans Only large fans Selling price ($) 32 54 Purchase price ($) 20 32.5 Delivery cost to customer ($ per fan) 1.0 1.5 Monthly fixed cost ($) 16,800 23,000 Average monthly sales volume (units) 1,800 1,300 Required: For each of the three…arrow_forwardIdentify the activity ratio of a computer shop is its Cost of Goods Sold is P12 million and the Average Inventory is P24 million.Show your solution, analyze and interpret your answer. Compute the return on asset of AR Grocery Store if the net profit after taxes is P10 million and its total assets is P100 million. Analyze and interpret your answer.arrow_forwardPLEASE, 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 FORMULASPLEASE, PERFORM THE EXERCISE IN EXCEL AND SHOW THE FORMULAS 10.-The company El Invierno, S.A., presents the following information for you to calculate its accounting and cash profit: Total Sales................................. $ 1'345,670.20 Cost of Sales.............................. $ 702,875.95 Operating Expenses: Wages and salaries.......... $149,516.40 Rent................................. 69,250.50 Commissions.................... 320,000.00 Depreciation.............. 114,129.32 $ 652,896.22 Sales, purchases and expenses were made in cash. Note:In the image, this is the original exercise, it is in Spanish, but it is easy to understand. Very important Note:It is necessary that you make a solution approach…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 LearningCornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage LearningManagerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
Cornerstones of Financial Accounting
Accounting
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Cengage Learning
Managerial Accounting: The Cornerstone of Busines...
Accounting
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
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