Q1. Sam's Bakery has sales of $576,000 with costs of $382,000. Interest expense is $15,000 and...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Q1. Sam's Bakery has sales of $576,000 with costs of $382,000. Interest expense is $15,000 and depreciation is $31,000. The tax rate is 27%. What is the net income? Show your work in Excel. Use Excel to caluclate the answer using functions & formulas as appropriate. Display your work with an arrangement similar to the oneon the right. Q2. Bob Equipment Rental paid $64 in dividends and $517 in interest expense. The addition to retained earnings is $327 and net new equity is $400. The tax rate is 27%. Sales are $14,900 and depreciation is $570. What are the earnings before interest and taxes? Q3. Suppose you are given the following information for Panola Bread: sales=$30,000; costs $10,000; addition to retained earnings =$4,365; dividends paid $485; interest expense $1,200; tax rate=30 percent. What is the amount of the depreciation expense? Q4. A firm has $345 in inventory, $942 in fixed assets, $210 in accounts recievables, $320 in accounts payable, and $65 in cash. What is the amount of the current assets? Q1. Sam's Bakery has sales of $576,000 with costs of $382,000. Interest expense is $15,000 and depreciation is $31,000. The tax rate is 27%. What is the net income? Show your work in Excel. Use Excel to caluclate the answer using functions & formulas as appropriate. Display your work with an arrangement similar to the oneon the right. Q2. Bob Equipment Rental paid $64 in dividends and $517 in interest expense. The addition to retained earnings is $327 and net new equity is $400. The tax rate is 27%. Sales are $14,900 and depreciation is $570. What are the earnings before interest and taxes? Q3. Suppose you are given the following information for Panola Bread: sales=$30,000; costs $10,000; addition to retained earnings =$4,365; dividends paid $485; interest expense $1,200; tax rate=30 percent. What is the amount of the depreciation expense? Q4. A firm has $345 in inventory, $942 in fixed assets, $210 in accounts recievables, $320 in accounts payable, and $65 in cash. What is the amount of the current assets?
Expert Answer:
Answer rating: 100% (QA)
Answer To solve these problems in Excel you can use the following formulas and functions 1 Net Incom... View the full answer
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these finance questions
-
Fujita, Incorporated, has no debt outstanding and a total market value of $450,000. Earnings before interest and taxes, EBIT, are projected to be $57,000 if economic conditions are normal. If there...
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
Question: Old MathJax webview Old MathJax webview i need ans of these question but the source is alot Old MathJax webviewOld MathJax webview i need ans of these question but the source is alot these...
-
ed The Engine Guys produces specialized engines for "snow climber buses. The company's normal monthly production volume is 2,500 engines, whereas its monthly production capacity is 5,000 engines. The...
-
What are the four main approaches to managing organizational change?
-
Frederick Industries changed from the double-declining-balance to the straight-line method in 2019 on all its plant assets. There was no change in the assets' residual values or useful lives. Plant...
-
If a bad debt is unexpectedly paid some years after it was written off, what would be the effect in the financial summaries for that year? a. Increase profit and decrease receivables balances b....
-
Reconstructing transactions involving short-term securities available for sale. During 2008, Zeff Corporation sold marketable securities for $14,000 that had a carrying value of $13,000 at the time...
-
Sunland Publishing Co. publishes college textbooks that are sold to bookstores on the following terms. Each title has a fixed wholesale price, terms f.o.b. shipping point, and payment is due 60 days...
-
Consider the problem of raising a real number x to the nth power, where n E {0,1,2,...}. Input: Real number x and n = {0,1,2,...}. Output: The value of x". 1. Write a (n)-time algorithm for the above...
-
Find the first order partial derivatives at point P(9.12). f(x,y) = In (x+ y- y)
-
Use cylindrical coordinates. Evaluate SSS 5x(x + y) dv, where E is the solid in the first octant that lies beneath the paraboloid z = 4 -x - y.
-
Ship A starts at a port and travels 6km at a bearing of 160 before changing to a bearing of 30 for 9km. How far from the port is Ship A after these two segments of travel, and at what bearing would...
-
For the pair of functions, write the composite function and its derivative in terms of one input variable. c(x) = 9x2-4; x(t) = 2 - 7t c(x(t)) dc dt Need Help? Read It Submit Answer 3. [-/2 Points]...
-
Minimum 8 references should be there Submission: For this assessment you need to submit two components: the written assignment (word document) A PDF copy of the study you appraised There is a Canvas...
-
Question 3 of 5 Step 1 of 1 00:47:27 There are 8 black balls and 7 red balls in an urn. If 5 balls are drawn without replacement, what is the probability that exactly 4 black balls are drawn? Express...
-
Carlton Stokes owns and operates a car-detailing business named SuperShine & Detailing. For $150, Carltons business will hand wash and wax customers cars, vacuum the interior, and thoroughly clean...
-
What is this project's discounted payback period? (10 points) a. 3.04 b. 3.24 c. 3.44 d. 3.64 Assume that the appropriate cost of capital for this project is 12 percent. Time 0 1 Cash Flow -$750 $400...
-
What is this project's IRR? a. 25.67% b. 27.19% c. 28.76% d. 29.86% Assume that the appropriate cost of capital for this project is 12 percent. 0 1 2 Time Cash Flow -$750 $400 $300 3 $200 4 $400
-
What is this project's Modified IRR (MIRR)? a. 18.78% b. 19.65% c. 20.14% d. 21.37% Assume that the appropriate cost of capital for this project is 12 percent. Time Cash Flow 0 1 -$750 $400 $300 2 3...
Study smarter with the SolutionInn App