Question: Pleae use formulas, not excel Your forecasted income statement shows sales of $992,000, cost of goods sold at $650,000, depreciation expense of $100,000, and a

Pleae use formulas, not excel

Your forecasted income statement shows sales of $992,000, cost of goods sold at $650,000, depreciation expense of $100,000, and a forecasted free cash flow of $390,200. What are your forecasted earnings? What is your tax rate

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!

On April 1, Jiro Nozomi created a new travel agency, Adventure Travel. The following transactions occurred during the company's first month. April 1 Nozomi invested $43.000 cash and computer...

please use formulas Flag question Your forecasted income statement shows sales of $992,000, cost of goods sold at $650,000, depreciation expense of $100,000, and a forecasted free cash flow of...

ENTER DATA ONLY FOR PRO FORM WITHOUT CORRECTIONS INCOME STATEMENT FORECAST FOR 2020 Total Sales $ Cost of Goods Sold $ Administrative expenses $ Depreciation $ Taxes $ Dividends $ BALANCE SHEET...

Please show formulas and calculations and not just results and numbers, and explain rationale for answers . You have the following information for Small Inc. for the current year (Y0). Assume there...

Page 1 FIN 610 Team Project Title: Financial Analysis Tasks Responding to the Controller Introduction: You are a financial analyst at the Stirm Windows Company. After the Monday morning staff meeting...

Your pro forma income statement shows sales of $ 992 comma 000, cost of goods sold as $ 491 comma 000, depreciation expense of $ 95 comma 000, and taxes of $ 162 comma 400 due to a tax rate of 40 %....

please need help clear Data Pop Corporation acquired 70 percent of Soda Company's voting common shares on January 1, 20X2, for $114,800. At that date, the noncontrolling interest had a fair value of...

File Home Insert Formulas Data Review View Automate Help Open in De Dvo Calibri v 11 B av av 21 fx B C F D Brendan's Bottled Water Ltd Income Statement Year 3 $500 Less: Sales Cost of Goods Sold...

Your projected income statement shows sales of $1 000 000, cost of goods sold as $519 000, depreciation expense of $103 000, and taxes of $113 400 due to a tax rate of 30%. What are your projected...

4.Your forecasted income statement shows sales of $1,362,000, cost of goods sold at $830,000, depreciation expense of $310,000, and a forecasted free cash flow of $470,200. What are your forecasted...

Hello Ruchi, I hope you have been doing good! I have attached the instructions word document and the excel workbook for part 5. This is the continuation from part 4. Please let me know if you have...

Potato farming (like farming of most agricultural products) is highly competitive. Price is determined by demand and supply. Based on U.S. Department of Agriculture statistics, U.S. demand for...

Write the query that will show only the duplicate customer records.

9 : 4 1 PM Tue 2 9 Apr 8 9 % Assignment 3 2 - Karim Corp. requires a minimum $ 8 , 0 0 0 cash balance. Loans taken to meet this requirement cost 1 % interest per month ( paid at the end of each month...

Analysis of the marketing mix for Omantel using 7 ps

Which is the most comprehensive measure of dispersion? a Range b Standard deviation c Percentiles d Mean

Which one of the following scales is commonly used to measure opinions in a questionnaire? a Ranking scale. b Nominal questions. c Likert rating scale. d Open question.

What depth of data analysis is required within the assessment criteria of your study centre for the qualification you are working towards?