Scenario In this project, you will step into the role of a financial analyst tasked with conducting a comprehensive financial analysis for a potential corporate investment opportunity. Your goal is to create a detailed financial analysis report that will guide the investment decision-making process for the corporation you select from the Final Project Student Spreadsheet, which is linked in the What to Submit section. You have been hired by a prominent financial consulting firm known for its expertise in providing data-driven insightsto corporations seeking to make informed investment decisions. Your firm has a reputation for delivering accurate financial analyses that aid companies in identifying profitable investment opportunities. Prompt Calculate stock and bond valuations for the company you selected from the first tab of the Final Project Student Spreadsheet and use the resultsto support your explanations of shareholder value and increasing capital. Assess the company's| dividend policies and bond issuance policies in your explanations. Complete your calculations on the Stock and Bond Valuation tab of the Final Project Student Spreadsheet. Specifically, the following critical elements must be addressed: II. II. Stock Valuation A. Based on the figures provided from the financial information you prepared for your selected company, calculate each of the following in Part I of the spreadsheet tab: Stock and Bond Valuation: prepared tor your selected company. 2. Identify the new dividend yields if the company increased its dividend per share by $1.75. 3. Identify the dividend yield if the firm doubled its outstanding shares using a stock split. Note that other numbers will be affected by a stock split such as new stock price, actual dividends paid, and number of outstanding shares. Stockholders' equity will not change. 4. Calculate the rate of return on investment based on the data you calculated in Question 1. B. What effect would each of the calculations you performed have on shareholder value? In other words, suppose the company's goal is to maximize shareholder value. How will each of the situations supportor inhibit that goal? Justify your reasoning through research, references, and citations using proper APA style. C. To what extent do you feel the company's dividend policies support or hinder its strategies? For example, if the company is attempting to grow, is it retaining and reinvesting its earnings rather than distributing them to investors through dividends? Support your claims through research, references, and citations using proper APA style. Bond Issuance A. Your selected company issues a new bond. Assume that your selected company issued a new 10-year bond for $300,000 on October 1, 2023. The bond will mature on October 1, 2033. The future value of this bond is $300,000. The bond was issued at the latest market rate of 5.0% fixed for 10 years, with interest payments paid semiannually. What is the completed in the Final Project Student Spreadsheet. Use double present value of this bond using the four scenarios in spacing, 12-point Times New Roman font, and one-inch margins. Part II of the spreadsheet tab: Stock and Bond Cite sources according to APA style. Your supporting research Valuation? should be as up to date as possible. Any news stories, press 1. Calculate the present value of the bond at releases, or additional sources must be dated within the last 60 issuance. days. Company data should be no more than one year old. Using 2. Calculate the new present value of the bond older data may result in being asked to resubmit your work. if overall rates in the market increase by 2%. 3. Calculate the new present value of the bond if overall rates in the market decrease by 2%. 4. Calculate the present value of the bond if Criteria Proficient (100%) Needs Improvement (80%) Not Evident (0%) Value overall rates in the market remain the same as Stock Valuation: Accurately calculates Calculates figures, but with Does not calculate figures 15 Calculations requested figures gaps in accuracy or detail at issuance. Stock Valuation: Analyzes the effects of each Analyzes the effects of each Does not analyze the effects 15 B. How would each of the calculations you performed Shareholder Value calculation on shareholder calculation on shareholder of each calculation on value, justifying reasoning value, but response or the shareholder value affect the company's decision to raise capital in this reasoning is cursory or illogical way? In other words, for each situation, would bond Stock Valuation: Assesses the extent to which Assesses the extent to which |Does not assess the extent to 15 valuation be a viable option for increasing capital? Dividend Policies dividend policies support or dividend policies support or which dividend policies hinder company strategies, hinder company strategies, support or hinder company Justify your reasoning through research, references, justifying the reasoning but response or the strategies and citations using proper APA style. reasoning is cursory or illogical C. Assess how bond issuance policies support or hinder Bond Issuance: Accurately calculates Calculates figures, but with Does not calculate figures 15 company strategies. For example, if the company is Bonds requested figures gaps in accuracy or detail Bond Issuance: Analyzes the effects of each Analyzes the effects of each Does not analyze the effects 15 attempting to fund operating expenses, refinance old Raising Capital calculation on the company's | calculation on the company's | of each calculation on the debt, or change its capital structure, is it issuing decision to raise capital, decision to raise capital, but company's decision to raise justifying the reasoning response or the reasoning is capital sufficient bonds to achieve these goals? Support cursory or illogica your claims through research, references, and Bond Issuance: Assesses how bond issuance Assesses how bond issuance | Does not assess how bond 15 Bond Issuance policies support or hinder policies support or hinder issuance policies support or citations using proper APA style. Policies company strategies, company strategies, but hinder company strategies justifying the reasoning response or the reasoning is cursory or illogical What to Submit Articulation of Submission has no major Submission has major errors Submission has critical 10 Your paper must be submitted as a 3- to 4-page Microsoft Word Response errors related to citations, related to citations, errors related to citations, grammar cnelling cuntav or Torammar cellino cuntav or |orammar enelling cuntay or