Reference no: EM132643855 
                                                                               
                                       
Make an Excel spreadsheet to organize your answers to the following problem, and submit your Excel file as an attachment by clicking on the appropriate button on this page.
A company with EBIT of $6,000,000 is considering two financing alternatives. The first alternative would have $25 million of bonds at 8% interest and 1,000,000 common shares outstanding, whereas the second would have $47.5 million of bonds at 8% interest and only 750,000 shares outstanding. The company is in the 35% tax bracket.
Part 1: Construct the bottom half of the income statement (including EPS) for each financing alternative when EBIT is at $6,000,000.
Part 2: Construct the bottom half of the income statement (including EPS) for each alternative if EBIT increases by 20%.
Part 3: Construct the bottom half of the income statement (including EPS) for each alternative if EBIT decreases by 20%.
Part 4: What is the EBIT/EPS indifference point for this firm?
Part 5: Comment on the results of your calculations above. What principle does this exercise demonstrate?
                                       
                                     
                                    
	
		| How the GDP Deflator equals
                                        : If nominal GDP equals $5,000 and real GDP equals $4,000, then the GDP Deflator equals? If nominal GDP equals $6,000 and GDP deflator equals 200, then real GDP | 
		| Discuss the purpose and importance of financial ratios
                                        : Discuss the purpose and importance of financial ratios and financial analysis. What are the limitations of financial ratio analysis? If we divided the users | 
		| Price ceilings often generate black markets
                                        : Economic analysis is used in all decision making. Price ceilings often generate black markets. The main source of government funding is user fees. | 
		| Analyze the rationale and purpose of the exclusionary rule
                                        : Write a 700- to 1,400-word paper in which you analyze the rationale and purpose of the exclusionary rule and identify exceptions to the rule. | 
		| Construct the bottom half of the income statement
                                        : Make an Excel spreadsheet to organize your answers to the following problem, and submit your Excel file as an attachment by clicking on the appropriate button o | 
		| Calculate the unemployment rate with the unemployed data
                                        : Calculate the unemployment rate with the following data: Unemployed: 10 million, US Population: 200 million, Employed: 90 million | 
		| Reviewing-analyzing a given firm
                                        : Why do many financial professionals 'start' with the statement of cash flows when they are reviewing/analyzing a given firm. | 
		| Denote the annual effective rates of the three schemes
                                        : Scheme I: Interest is compounded at a rate of r at the end of every month. | 
		| Which of the individuals are counted as unemployed
                                        : Which of the individuals are counted as unemployed? An adult who is out of work, wants a job, and applied to a job 2 weeks ago but not since then. |