mis

Pre

Intro

Watch NPV and IRR Real Life Example Using Solver.Then, conduct the same calculation using the attached spreadsheet, changing the Current House Price to $538,000 USD and leaving all other values unchanged. What is the yearly rate of return? Is this what you would expect the new yearly rate of return to be? Explain why. Download file by clicking on the link below:@@PLUGINFILE@@/LearningSkill7_CondoIncomeCalculator_Solution.xlsx?time=1756973102387

After viewing the Cash Flow Forecasting Explained video, respond to the following:You are the financial manager for a large electronics retailer. What benefits could you gain from preparing a cash forecast? Identify at least 5. Limit your answer to no more than 300 words.

Complete the following statements by either filling in the missing word or selecting the correct option from the two choices given in parentheses (X/X or X/X/X):The ___________ analysis is a type of financial statement analysis which is most commonly used to create a baseline estimate for financial forecasts.The ___________ on the income statement is a key element, which is used to estimate several other key income statement lines.In the context of a firm’s financial statements, pro forma means historical/forward-looking/audited.The most common length of a forecast if the goal is to forecast cash and assess possible short-term growth, is ________.When completing a first pass at a forecasted income statement, variable/fixed costs are assumed to be tied directly to sales.In the cash forecast, if cash inflows exceed cash outflows, this creates a cash deficit/surplus.

Instructions: Questions 2 to 6 should be completed in Excel.ABC Company anticipates its sales to be slightly lower than normal in January and February of the coming year due to major road construction on the street where it is located, which will divert foot traffic away from the store. The company anticipates that this will result in a 5% reduction in sales over the next two months. Use the information from Questions 2 and 3 to update the sales forecast.

After viewing the Optimal Capital Structure Lesson video, which discusses the optimal capital structure for real estate, answer the following questions:Explain in no more than 350 words why the optimal capital structure for commercial real estate cannot be uniform (i.e., a “one-size fits all”) for all commercial real estate entities. Present a scenario where you would recommend a highly levered capital structure and a scenario when you would recommend an unlevered capital structure in the commercial real-estate market, and explain why.  

Complete the following statements by either filling in the missing word or selecting the correct option from the two choices given in parentheses (X/X or X/X/X):The capital structure of a company refers to the proportion of _______ and _______ the company uses in financing its assets.When calculating the weights of a company’s capital structure, the book value/current market value should be used.Two methods for estimating a company’s cost of common stock capital are _______ and ________.Using the yield to maturity on the company’ existing bonds is the most reasonable way to calculate the ________ for that company.Net debt equals the _______ less the _______ and ___________ assets the company owns. The interest tax shield occurs because interest payments are a _______ expense.As a company increases the weight of debt in its capital structure, its possibility of financial distress increases/decreases/does not change.A company is said to be in financial distress if it has difficulty meeting its ___________.The _________is the return the company must offer to use the funds of investors.The trade-off theory suggests that there is an advantage and a disadvantage to increasing the weight of debt in the capital structure. Increasing the amount of debt used increases the interest tax shield, thereby increasing/decreasing the value of the firm. At the same time, increasing the amount of debt increases/decreases the risk of financial distress, which carries both direct and indirect costs. 

Optimist Company can sell common shares at $30 per share and obtain debt funding at 8 percent. It has a marginal income tax rate of 25 percent. The yield on US Treasury securities is 3 percent. The market risk premium is 6.0 percent, and the firm’s beta is 0.9. It has a targeted debt-to-equity ratio of 1:1. What is its after-tax cost of debt?