Question: 18. Please solve in Excel and round to 3 decimal points. Project A has projected sales of $585,000. Variable costs are 44% of sales, fixed

18. Please solve in Excel and round to 3 decimal points.

Project A has projected sales of $585,000. Variable costs are 44% of sales, fixed costs are $187,000, depreciation is $51,000.

Prepare a pro forma income statement using Excel assuming a tax rate of 21%.

What is the projected net income?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Q:

Lily Tucker ( single ) owns and operates a bike shop as a sole proprietorship. In 2 0 2 4 , she sells the following long - term assets used in her business: Lily's taxable income before these...

Q:

solve this please uestion 4 (1 point) O'Reilly Manufacturing provided the following information for last month: Sales $20 000 Variable costs 6000 Fixed costs 5000 Operating profit $9000 If sales...

Q:

S10-02 Relevant Cash Flows [LO1] Winnebagel Corp. currently sells 20,000 motor homes per year at $97,000 each and 14,000 luxury motor coaches per year at $145,000 each. The company wants to Introduce...

Q:

Hello, Please can someone tell me how to calculate the break even point on Chapter 11 Question 7. Please see the attached. Thank you, Cindy Chapter 9 Question 7 Calculating IRR [LO5] A firm evaluates...

Q:

help.. COMBINED CASH BUDGET LAB 7 Now that the operating budgets are complete, Tonia and Tara prepare a combined cash budget for the upcoming year. Based on the forecasted cash balances each month,...

Q:

This is the 3rd post so please provide the correct & complete answers this time, thanks in advance. 3. (a) If the new equipment is purchased, what is the projected increase in after-tax cash inflow...

Q:

Please answer all the questions Below is data from the case. Use the Westfield Corporation Excel documents for questions 3 to 18. 4. How is each category from \#3 usually classified (variable or...

Q:

Managerial Accounting I need help with creating an executive summary Using the information from the excel spread sheets and scenario attached. The assignment instructions for the Executive Summary...

Q:

Managerial Accounting I need help with creating an executive summary Using the information from the excel spread sheets and scenario attached. The assignment instructions for the Executive Summary...

Q:

Ray Summers Company operates at full capacity of 10.840 units per year. The company, however, is still unable to fully meet the demand for its product, estimated at 15,000 units annually. This level...

Q:

PLEASE SHOW EXCEL FORMULAS PLEASE SHOW EXCEL FORMULAS A B C D E F I J K L . M N 0 P Leather Goods LLC produces and sells leather goods. Their current product mix consists of wallets, weekender bags...

Q:

Electrons and protons travel from the Sun to the Earth at a typical velocity of 4.00 × 10 5 m/s in the positive x-direction. Thousands of miles from Earth, they interact with Earths magnetic...

Q:

What is production control?

Q:

What does the phase" Accounting for Decision Making and Control" mean to you

Q:

Violins-by-Zain produces student-grade violins for beginning violin students. The company produced 2,000 violins in its first month of operations. At month-end, 600 finished violins remained unsold....

Q:

If you have not completed that problem, do so at this time. Required a. ErgoFurn incurred $395,000 in manufacturing overhead in December. Given that expenditure, was manufacturing overhead under- or...

Q:

Leimersheim GmbH has adopted the following policies regarding merchandise purchases and inventory. At the end of any month, the inventory should be 15,000 plus 90% of the cost of goods to be sold...

Q:

Zelmer Company manufactures tablecloths. Sales have grown rapidly over the past 2 years. As a result, the president has installed a budgetary control system for 2017. The following data were used in...

Q:

ErgoFurn, Inc. manufactures ergonomically designed computer furniture. ErgoFurn uses a job order costing system. On November 30, the Work in Process Inventory consisted of the following jobs: On...

Q:

? ? r e f e r s t o a s i t u a t i o n w h e r e a c o m p a n y u s e s t h e s a m e b r a n d n a m e a c r o s s a v a r i e t y o f p r o d u c t c a t e g o r i e s Question 1 options: Family...

Q:

Using a training topic (or module) of your choice, what audiovisual media would be most appropriate in presenting this method to a group of trainees? Why did you pick the media or methods that you...

Q:

Compare the five categories of classroom training presented in this chapter to Neil Flemings preferences for taking in information, that is, the VARK questionnaire presented in Chapter 3 (VARK stands...

Q:

Why do you suppose the five categories of classroom training are so popular in HRD? Identify two types of training programs a manager might not want to conduct in using a classroom format.