Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Jul 20, 2024

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

Step: 1

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

Step: 3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fixed Income Securities Tools For Todays Markets

Authors: Bruce Tuckman, Angel Serrat

3rd Edition

0470891696, 978-0470891698

More Books

Students also viewed these Finance questions

Question

★★★★★

A sample of clayey silt is mixed at about its LL of 43. It is placed carefully in a small porcelain dish with a volume of 18.9 cm3 and weighs 33.89 g. After oven drying, the soil pat displaces 212.4...

Answered: 1 week ago

Question

★★★★★

The pipe ACDE is supported by ball-and-socket joints at A and E and by the wire DF. Determine the tension in the wire when a 640-N load is applied at B as shown. 200 mm 490 mm 640 N 160 mim 480 mm...

Answered: 1 week ago

Question

★★★★★

1. Think out loud as you solve problems.

Answered: 1 week ago

Question

★★★★★

Deanna Nardelli started her own consulting firm, Nardelli Consulting, on May 1, 2019. The trial balance at May 31 is as follows. In addition to those accounts listed on the trial balance, the chart...

Answered: 1 week ago

Question

★★★★★

Write a short program in C+ that will display the following information: "Code Name Name: Email Hometown: High School(s): Previous colleges: List college math/CS courses: What, when, and where was...

Answered: 1 week ago

Question

★★★★★

Teacher's Helper is a small company that has a subcontract to produce instructional materials for children in public school districts. The owner rents several small rooms in an office building for RM...

Answered: 1 week ago

Question

★★★★★

Case D Mr. Smith was transferred from the Coronary Care Unit to a semi-private room in Hapless Hospital. He decided to leave the hospital because he did not like his new accommodations or having a...

Answered: 1 week ago

Question

★★★★★

Think about Goleman's 6 leadership styles, and discuss how you think Goleman's leadership styles relate to the 4 quadrants of EI and the leadership styles outlined in this leadership questionnaire....

Answered: 1 week ago

Question

★★★★★

In explaining why monetary policy did not pull Japan out of a recession in the early 2000s, an official at the Bank of Japan was quoted as saying that despite "major increases in the money supply"...

Answered: 1 week ago

Question

★★★★★

2. [4 points] Find the constrained minimum and maximum values of the function f(x, y) = (x-2y)2 subject to the constraint x + y = 5, as well as all points at which they occur.

Answered: 1 week ago

Question

★★★★★

The FDIC asserted gross negligence by Crowe. Allegedly, there was concealment and collusion to pep petrate a fraud within the bank and from outside sources. Crowe was held to the AICPA's standards...

Answered: 1 week ago

Question

★★★★★

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...

Answered: 1 week ago

Question

★★★★★

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...

Answered: 1 week ago

Question

★★★★★

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.

Answered: 1 week ago

Previous Question Next Question