Boost your journey with 24/7 access to skilled experts, offering unmatched financial cases and modeling homework help

**Q1:**Question 2 2.1 Madeira has an ambitious plan to invest 1 billion AED in the next 5 years. Explain how the company might fund such an ambitious investment plan. You are required to evaluate the benefits and drawbacks of equity finance and debt finance from the company's perspective. (10 marks) 2.2 Summarise the (theoretical) costs of each type of finance available to the company when funding its investment appraisal in the future. What are the relative costs of retained earnings compared with raising new finance via the financial markets.See Answer**Q2:**Question 4 4.1 The fundamentals of finance are said to be the concept of "Risk and Return" and secondly the Time Value of Money. Critically evaluate how investment appraisal techniques can take account of both fundamental theories to aid decision making (10 marks) 4.2 Summarise the benefits of Leasing to the company when obtaining new fixed assetsSee Answer**Q3:**Need to detect problem from the given two case studies and find solutionSee Answer**Q4:**Assume a 38% tax rate and a 10% discount rate when discounting future dividends. Assume that the new debt is constant and perpetual and that the buyback operation is unexpected by stock market participants. 1) What are the primary business risks of UST? Evaluate them from the point of view of a bondholder. 2) Why is UST considering a leveraged recapitalization after such a long history of conservative debt policy? 3) Should UST undertake the $1bn recapitalization? Prepare a pro-forma income statement for 1999 to analyze whether UST will be able to make interest rate payments. How sensitive is your conclusion to the rating UST bonds receive?See Answer**Q5:**NENT FOUR For the following problem, give answers correct to five significant figures for calculations of R in your answers be sure to define annuities and perpetuities in context. a. b. For an investment of $550 000, an annuity with an interest rate of 5.39% p.a. will give a greater monthly payment than a perpetuity with an interest rate of 5.4% p.a. Assume that the annuity will last 20 years. Compare an annuity and perpetuity: compare the two options, suggest which option is better, include calculations and justify your answer. A housing loan of $380 000 is taken out for 15 years. Interest is charged at 9% per annum adjusted (compounded) monthly. The debt is to be repaid in monthly instalments. Complete the amortisation table for the first five months, assuming $3854 is paid each month. Payment Number Payment Made Interest Paid ($) ($) 0.00 0.00 3854.00 n 241 0 1 2 3 4 5 Total Principal Reduction ($) 0.00 Balance Remaining (5) 380 000.00 378 996.00See Answer**Q6:**Stuarts Bank ANALYZE AND CHART FINANCIAL DATA GETTING STARTED Open the file Data Visualization.xlsx, available for download from blackboard. Save the file as U7 Data Visualization AS2. PROJECT STEPS 1. Kayla Rowe is an investment banker at Stuarts Bank in New York City. She is working with a software company called Caretaker Mobile Apps, which is developing an app that detects and manages smart devices in a customer's home. To help Caretaker Mobile Apps secure funding for its new product, Kayla is using an Excel workbook to analyze their expenses and funding options and to create charts that illustrate the analysis. 2. 3. 4. Switch to the Current Expenses worksheet. In the range E5:E9, add Conditional Formatting to compare the Quarter 4 expenses using Gradient Fill Blue Data Bars. In the range F5:F10, add Line sparklines based on the data in the range B5:E10 to compare each category of expense and total expenses from Quarter 1 to Quarter 4. Apply the Red, Accent 6 (10th column, 1st row in the Theme Colors palette) sparkline color to the sparklines to contrast with the data in the worksheet. Kayla created a pie chart comparing how each type of expense relates to the total expenses in Quarter 1. Modify the pie chart in the range G4:022 as follows to make it more meaningful:/n5. 6. a. b. C. Enter Quarter 1 Expenses as the chart title. Change the data labels to include the Category Name, and position the labels in the Inside End location to clarify what each piece represents. a. b. Remove the Legend from the chart because it now repeats information in the data labels. Kayla also wants to compare how each type of expense relates to the total expenses in Quarter 4. Create a chart as follows to compare the expenses: Create a 2-D Pie chart based on data in the nonadjacent ranges A5:A9 and E5:E9. Resize and reposition the chart so that the upper-left corner is located within cell G23 and the lower-right corner is located within cell 039, then left-align the chart with the pie chart above it in the range G4:022. Customize the new pie chart in the range G23:039 as follows to clarify its purpose and match the format of the other pie chart: a. Enter Quarter 4 Expenses as the chart title. b. Apply Style 11 to the chart./n7. 8. 9. 10. Kayla also wants to compare the five types of expenses in each quarter. Create a chart as follows to provide this information: Create a Stacked Bar chart based on the data in the range A4:E9. Resize and reposition the chart so that the upper-left corner is located within cell A11 and the lower-right corner is located within cell F28. a. b. Customize the stacked bar chart in the range A11:F28 as follows to make it easier to interpret: a. b. C. Kayla wants the Projected Expenses 2022 2025 combo chart to appear on a different worksheet. Move the chart as follows: a. b. Move the combo chart in the range A35:F62 to the Projected Expenses worksheet. Resize and reposition the chart so that the upper-left corner is located within cell A12 and the lower-right corner is located within cell J35. Customize the combo chart as follows to clarify its data: Apply the Monochromatic Palette 3 color scheme to the chart. Add a secondary axis for the Total series. [Mac Hint: Select the Total series and use the format pane to add the axis.] Enter Expenses per Quarter as the chart title. Change the Maximum value to $1,400,000 on the horizontal axis. Apply a shape fill of Indigo, Text 2, Lighter 80% (4th column, 2nd row in the Theme Colors palette) to the chart area to contrast with the other charts in the worksheet. a. b./n10. b. Customize the combo chart as follows to clarify its data: Apply the Monochromatic Palette 3 color scheme to the chart. Add a secondary axis for the Total series. [Mac Hint: Select the Total series and use the format pane to add the axis.] a. b. C. Resize and reposition the chart so that the upper-left corner is located within cell A12 and the lower-right corner is located within cell J35. 11. Kayla wants to compare three options for Caretaker Mobile Apps to borrow $725,000 to fund the development of their new product. Switch to the Funding worksheet. She has already entered formulas in the range B11:D12 to calculate the quarterly and annual payments for each option. Add Vertical Axis Titles to the chart, using Expenses per Category as the Left Vertical Axis Title and Total Expenses as the Right Vertical Axis Title. Finally, delete the horizontal axis title placeholder because that axis clearly represents years. In the range E11:E12, add Column sparklines using the data in the range B11:D12. Ungroup the sparklines, and then change the vertical axis maximum value to -16000 for cell E11 and to -60000 for cell E12. a. 12. Kayla wants a clustered column chart comparing the costs of the funding options. Create a Clustered Column chart based on the values in the range A11:D12. Resize and reposition the chart so that the upper-left corner is located within cell A13 and the lower-right corner is located within cell D30. b./n13. Customize the chart in the range A13:D30 as follows: a. b. C. Enter Funding Options Comparison as the chart title. Add a Data Table With Legend Keys to the chart. Apply a 11 point border to the chart area, and then change the border color to Blue, Accent 4 (8th column, 1st row of the Theme Colors palette). Your workbook should look like the Final Figures on the following pages. Save your changes, close the workbook, and then exit Excel. Upload to blackbaord for grading.See Answer**Q7:**Housing Case Facts Adam and Mindy own their home in Nacogdoches, Texas, currently assessed for property taxes at $450,000, and aggregate property taxes run 2.22% of taxable value annually. Their original mortgage, taken out five years ago, was for $425 000 financed for 30 years at 3.75%. Their monthly mortgage payment for principal and interest is $, and after making 59 monthly payments, their current mortgage balance is $ The annual cost of their homeowner's insurance is $2,920. They are considering refinancing their homeloan, and are curious how amortization works. They request you build them an amortization schedule on their current mortgage so they can see for themselves the change in interest and principal over time. Additionally, they are considering refinancing options for the remaining balance of home and are considering a 15-year and 30-year mortgages as options. Based on their credit score and debt-to-income ratio, the 15-year mortgage has an interest rate of 4.5% APY, and the 30-year mortgage has an interest rate of 5.5% APY. They are wanting you to build amortization schedules for their current mortgage and both the 15-year and 30-year options so they can compare over time. They want to know what the total cost of their current mortgage is if they were to retain it and pay for the entire 30 years. They are also curious what the total cost of the 15-year and 30-year refinance options would be if they chose to refinance. They would like you to break it down for them: total interest paid, total principal paid, and total cost if they maintained/pursued each option. Remember, they are 5 years into their current loan. They would also like you to reveal to them what their new financial ratios are/would be with each option so they can consider the impact on future goals. The two ratios they are concerned with are the Housing Ratio Expense (Front Cost Ratio) and the Total Debt to Income Ratio (Back End Ratio) {you'll need to use data from the previous case study, particularly Recurring Debt Payments}. They would like the amortization schedules in Excel format, and they would like a write up in a Word document explaining the details of each option and your recommendation for or against each option. Please do not to forget each option's impact on the 2 financial ratios they are mainly concerned with./nAdam drives a 2018 Audi with a blue book value of $8,000 (fully paid for), while Mindy just bought a 2020 Toyota (January 1, 2020) that cost her $35,500. She was miserable when she - at the urging of her husband-checked her new car's blue book value and saw that her car's value had depreciated to $28,500 in the short time she had the vehicle. Her original loan was for $32,000, financed for five years at 3.5%. Her monthly payment is $ Adam believes his 2018 Audi is about to give out on him and is considering either purchasing a new car or leasing one. He is a little risk averse when it comes to maintenance and is wondering if leasing would be a better fit for him. He would trade his car in if he decided to purchase and can get what the Blue Book Value is. He would like you to provide a Lease/Buy analysis for him. He's looking at a 2023 Lexus ES Ultra Luxury 4Dr. Sedan. He only drives the Audi to and from work and on the weekends to take Mindy on dates. His current vehicle has 56,000 miles. He's not sure if he should lease the vehicle for 24 months, 36 months, 48 months, or if he should just purchase the vehicle. He was just pre-approved for a 5-year loan with a 0% down payment and 3.5% APY (compounded monthly). For the purchase option, he would like an amortization schedule in Excel so he can see over time the changes in principal and interest. He would also like a breakdown of the total cost, principal, and interest paid over the life of the auto loan. For the lease, he would like a break down of all the costs associated with a lease, including monthly payments, all amounts due at signing (taxes, title, etc.), and total cost of the lease for each option (36, 48, and 60 months) and at each mileage option (10k, 12k, 15k). Adam would like all analyses to be done in excel, and a Word document detailing your recommendation. State tax rate is 8.25% (applies to both purchase or lease) Title and Registration is 5% of the car value (to be financed in both lease or purchase) Amount due at signing is 8% of the car value (Lease only) $100 Acquisition fee (Lease only) $250 Security deposit (Lease only) Leasing info Do not use this site for the purchase details, only for the leasing details.See Answer**Q8:**Questions: 1. (30 pts) Use S&P 500 Company Data.xlsx to answer the following questions (in data file) a) Create a calculated column that calculates the total return for the last three years. Name it "Total Return 3 Yr." Use Get & Transform to remove # N/A values from the calculated column. Make a pivot table that shows the three-year total return (average) by GICS Sector. b) Create a pivot column chart that show the data from part a. Which GICS sector has the lowest total return for the last three years? c) Now add the GICS Industry field to the pivot table. Which industry was the best performer in the worst sector over the past three years? Sort the fields in your pivot table so that this sector and industry is at the very top of the table. d) Create a new pivot table from the original data that shows the top 20 GICS Sub-Industries by average of market capitalization (market value). Also include a count of the number of companies in each sub-industry. (Moving Symbol to Values will create a count of Symbol, which gives you the # of count.) e) Use Get & Transform to remove errors from the net profit margin column, and then create a pivot table that shows the average net profit margin by GICS Industry. Which is the most profitable industry? Which is the least profitable industry? f) Create a pivot table that shows beta and the Total Return 3 Yr for each company. Now, copy and paste the data to another location in the same sheet. Create a regular XY scatter chart of the data. Is there a relationship between beta and historical three-year returns?See Answer**Q9:**2. (35 pts) The financial statements of Rhodes Corporation are shown above. a) Recreate the income statement and balance sheet using formulas wherever possible. Each statement should be on a separate worksheet. Please show all dollar amount to thousands of dollars. b) On another sheet, create a statement of cash flows for 2019. Do not enter any numbers directly on this sheet. All formulas should be linked directly to the source on previous worksheets. c) Using Excel's outlining feature, create an outline on the statement of cash flows that, when collapsed, shows only the subtotals for each section. d) Create a common-size statement of cash flows for 2019 that can be switched between using sales and the 2018 cash balance in the denominator.See Answer**Q10:**3. (35 pts) Forecasting Rhodes Corporation financial statement Forecast 2020 income statement and balance sheet using the percent of sales method and the following assumptions: (1) sales in 2020 will be 12.5 million; (2) tax rate keeps the same; (3) each item that changes with sales will be the 2 year average percentage of sales; (4) fixed asset will increase $1,000,000 with a 10 year straight line depreciation schedule with 0 salvage value; (5) the common stock dividends will be $202,000; (6) interest rate on short-term and long-term debt will be 9%; (7) Cash, short-term investment will be the same as 2019; (8) COGS, Selling G&A expenses, A/R, inventory, A/P, Accruals will change in proportion to sales; (9) Notes payable and long-term debt will keep the same; and if there is borrowing need, the company will borrow from long-term debt; (10) the company will not issue stocks in 2020. a) What is the additional funds needed in 2020? Is this a surplus or deficit or balanced? (Without iteration, or borrowing happens at last day of the year) b) Assume that the AFN will be absorbed by long-term debt, set up an iterative worksheet to find total accumulated AFN (borrowing happens during the year) c) Why accumulated AFN increases in part b)? Please explain the phenomenon.See Answer**Q11:**1.1 Calculate the following ratios for Madeira Plc: Gross Profit Margin Net Profit Margin Net Asset Turnover Receivable Days Payable Days Return on Capital Employed Debt/Equity Ratio Return on Equity (12 marks) 1.2 Comment on the financial performance of Madeira Plc between the years 2019 and 2021 using the ratios above and any other financial measure you feel appropriate. (10 marks) 1.3 In 2019 the share price of Madeira was 2 AED per share. Today the share price is 5 AED per share. Critically evaluate if you believe the directors of Madeira Plc are maximising the wealth of shareholders. What other goals might the company consider.See Answer**Q12:**Question 3 Blue Moon plc is looking to take on a new investment. The company will evaluate two mutually exclusive projects, whose details are given below. The company's cost of capital is 12%.See Answer**Q13:**1 What is partnership ordinary income for Focus LLC (Form 1065, page 1, line 22) 2 Please complete the information for Schedule K of Form 1065, lines 1-13 for Focus LLC. In addition use this tab to enter the member's share next to it that you would enter on the real Schedule K-1 3 What is the Analysis of Net Income (Loss) found on Form 1065, page 5, Line 1 for Focus LLC 4 What is Molly's tax basis in Focus LLC as of December 31, 2021. 5 What is Molly's ending tax capital account in Focus LLC. On December 31,2021. 6 What are the tax implications for Molly's contribution of services in exchange for a fully vested capital and profits interest? 7 What is Shelby's tax basis in Focus LLC as of December 31, 2021? 8 Shelby's ending tax capital account as of December 31, 2021 9 Bankroll's tax basis in its investment in Focus LLC as of December 31, 2021 O Bankroll's ending tax capital account in Focus LLC as of December 31, 2021 1 Bankroll's taxable income for the year ended December 31, 2021 2 What is the tax treatment for the distributions made for both Travis and Judy 3 Travis's tax basis in Bankroll's stock as of January 1, 2022 4 Judy's tax basis in Bankroll's stock as of January 1, 2022 5 What would have happened if Bankroll would have structured itself as a partnership or an S Corp - list some ways that your answers would have changed and which entity you would have recommended and why.See Answer**Q14:**1. What is "Cost of Capital"? Why do Dale and Lee care about the cost of capital/See Answer**Q15:**2. Create a table of all the sources of Financing for Walmart. Use the Balance Sheet that you are provided. You should be able to determine Long-term Debt, Short term debt, Sources of equity financing.See Answer**Q16:**3. Determine which source of debt should be used in calculating the cost of long-term debt. What is the cost of long-term debt? (Need to list source and cost)See Answer**Q17:**Using the Capital Asset Pricing model, determine the Cost of Equity.See Answer**Q18:**5. Create a revised table of sources of financing and determine the Debt-Equity ratio.See Answer**Q19:**7. Ultimately Dale and Lee need to determine a hurdle rate or a Minimum Attractive Rate of Return (MARR). What should that value be and why?See Answer**Q20:**Accounting 420/5559 Intercompany equipment transactions in a worksheet Parent acquired shares of subsidiary asSee Answer

I found TutorBin Financial Cases And Modeling homework help when I was struggling with complex concepts. Experts provided step-wise explanations and examples to help me understand concepts clearly.

Rick Jordon

5

TutorBin experts resolve your doubts without making you wait for long. Their experts are responsive & available 24/7 whenever you need Financial Cases And Modeling subject guidance.

Andrea Jacobs

5

I trust TutorBin for assisting me in completing Financial Cases And Modeling assignments with quality and 100% accuracy. Experts are polite, listen to my problems, and have extensive experience in their domain.

Lilian King

5

I got my Financial Cases And Modeling homework done on time. My assignment is proofread and edited by professionals. Got zero plagiarism as experts developed my assignment from scratch. Feel relieved and super excited.

Joey Dip

5

TutorBin believes that distance should never be a barrier to learning. Over 500000+ orders and 100000+ happy customers explain TutorBin has become the name that keeps learning fun in the UK, USA, Canada, Australia, Singapore, and UAE.