Question: please show steps and formula on excel A project has cash sales of $19,270, cash expenses of $9,760, depreciation expense of $2,130 and interest expense

please show steps and formula on excel

A project has cash sales of $19,270, cash expenses of $9,760, depreciation expense of $2,130 and interest expense of $1,620. The tax rate is 30%. What is operating cash flow? $7,296 $6,162 0 $4,344 $8,787

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!

AW 200 ( 41.7 wide-flange beam (see Table E-1(b). Appendix E) is simply supported with a span length of 2.5 m (see figure). The beam supports a concentrated load of 100 kN at 0.9 m from support B. At...

accounting 2 please show steps and formuals in excel !!! please help!!!! Draw Formulas Insert Data Review View Page Layout Home Tell me 12 ' ' Arial = Wrap Text X LD * V Paste ov Merge & cer a. Av E9...

HELLO, I HAVE POSTED THIS QUESTION BEFORE AND IT SEEMS TO BE THE CORRECT ANSWER HOWEVER, WHENEVER I TRY TO DO THE FORMULA ON THE ASSIGNMENT IT TELLS ME INCORRECT, AND I'M VERY CONFUSED ABOUT WHAT I...

all aswers must show formula Use the income statement and balance sheet to prepare a statement of cash flows using the indirect method ? Prepare a statement of cash flows using the indirect method -...

I I MUST HAVE THE FORMULA PLEASE ATTACH IT WITH THE ANSWERS. THANK YOU IN ADVANCE 34 26 Interest payable 3,400 2,300 27 Income tax payable 30,200 32,500 28 Long-term liabilities: 29 Notes payable...

Pro forma statements of profit or loss for financial years ended 2022 to 2025 (in HKD mn) Sales revenue Actual 2021 Costs of goods sold Sales growth rate Costs of goods sold as a percentage of sales...

I need help completing the tax forms using the provided information... The excel attachment has multiple tabs... 1120 U.S. Corporation Income Tax Return Form Department of the Treasury Internal...

Resources:Phoenix Medical Data Part 3,Phoenix Medical Worksheet Student Part 3,Schedule K-1 Instructions,Schedule K-1 Form 1065, Instructions Form 1065, andReturn Form 1065 Using the included...

Hi there. Could you help me calculate beginning and ending capital from the attached spreadsheet, as well as, utilizing such data to complete a Schedule K-1 for the indicated partner (indicated on...

Having a lot of trouble with the final page of this form 1120. Just don't know where to pull my data from. Also could use a little help double checking what I have already. 1120 U.S. Corporation...

I need help with filling out this tax form 1120. All information needed for this assignment is in the excel spreadsheet. I need this done by the end of today if possible. Thank you! 1120 U.S....

Gubanich Sportswear is considering building a new factory to produce aluminum baseball bats. This project would require an initial cash outlay of $ 5,000,000 and will generate annual free cash...

Atmospheric air of 40% relative humidity and temperature T = 300 K is in parallel flow over a series of water-filled trays, with U = 12 m/s. What is the rate at which energy must be supplied to ach...

a Copy and complete this table of values for the function y = 2x + 6 b Use the table to plot a graph of y = 2x + 6 c Extend the line on the graph to show that it goes through the point (3, 12). d...

9. (15 points) A company is considering a new project that requires an investment of \$5 million. The project is expected to generate cash flows of $2 million in year 1,$3 million in year 2, and $4...

Technology. Your instructor has asked you to speak to the faculty club at your school. Your speech is to be about the benefits of membership in student organizations. You are unable to make the...

Seafood Specialties Restaurant offers a shrimp and lobster tail special each Friday evening.You are manager of the restaurant. On Tuesday, you received a request from a customer, Shipley Masters, who...

You are the customer service representative for Fly High Airline. The airline awards frequent flyer miles but charges a $50 fee per ticket unless the free flight is booked more than 14 days in...