these questions are hard I really need help, thank you.
Enter numbers in the "Cost" column as percentages rounded to 3 decimal places. Enter whole numbers only in the "Value" column and base your weights on those whole numbers. Enter numbers in the "Weight" column as percentages rounded to 2 decimal places. COST VALUE WEIGHT (3 decimal (Whole 2 decimal SOURCE OF CAPITAL places) numbers) places) Bank Loan (interest only) Before-tax cost of bank loan Market value of bank loan Mortgage Loans Before-tax cost of mortgage loan Market value of mortgage loan Corporate Bonds Credit spread basis points Credit spread as a percentage (2 decimal places) Risk-free rate to be used to calculate cost of corporate bonds (3 decimal places) Before-tax cost of corporate bonds Face value of all bonds Coupon rate Number of years to maturity Number of coupon payments per year Total number of coupon payments remaining Total value of all coupon payments paid per year Value of each individual coupon payment Semi-annual yield (3 decimal places) Value of corporate bonds Ordinary Shares Risk-free rate to be used to calculate cost of ordinary shares (3 decimal places) Beta Risk premium Cost of ordinary shares You may not need every line in the following table of dividends. Only enter the dividends needed to calculate the share price. Enter the actual dividends - not their present value - rounded to 4 decimal places. Time value of money calculations should be done in the final step when you calculate the share price. Dividend 1 year from now Dividend 2 years from now Dividend 3 years from now Dividend 4 years from now Dividend 5 years from now Dividend 6 years from now Price of ordinary shares (Round to 2 decimal places) Number of ordinary shares Total market value of ordinary shares Preference Shares Preference dividend per share Preference share price Cost of preference shares Number of preference shares Total market value of preference shares so 0% Tax Rate All of the weighted costs below should be after-tax costs (where applicable), as percentages rounded to 2 decimal places Weighted Cost of the Bank Loan (i.e. cost x weight) Weighted Cost of the Mortgage Loan Weighted Cost of the Corporate Bonds Weighted Cost of the Ordinary Shares Weighted Cost of the Preference Shares Weighted Average Cost of CapitalPART 2 - PROJECT EVALUATION Year WACC: Opening Book Value less Depreciation Tax Rate: Closing Book Value Round off all dollar values below to the nearest whole number. All Revenue and expenses expenses and cash outflows must be negative numbers. Read the Important Note to the right.) IMPORTANT NOTE The description fields in the first column are designed to use dropdown boxes. Unless you enter descriptions that exactly match the descriptions in those dropdown boxes, you will be marked as incorrect. If your device or software does not support dropdown boxes (i.e. you are able to type anything in the first column), it is critically important that you enter descriptions that exactly match the descriptions in the folllowing list, including capitalisation, spelling and punctuation. If you find you cannot select from dropdown boxes when entering descriptions in the first column, it is strongly recommended that you copy and paste descriptions from the following list. Incremental EBIT less Tax Incremental Earnings 0 less Feasibility Study Salvage Value Other cash flows less Depreciation [The Important Note also applies.) plus Depreciation Less Maintenance Revenue Net Working Capital less Opportunity Cost (Rent) Purchase of Equipment less Tax on Profit on Sale of Asset less Operating Costs Incremental Free Cash Flows 0 0 0 0 NPV Payback Period years Or tick this box if the outlay is IRR Profitability Index never recovered. Should the project be accepted? (Enter YES or NO in capital letters) Why/why not? Please select all of the following that apply The project should be XXX because... You must make a recommendation to accept or reject the project before these options can be displayed. You must make a recommendation to accept or reject the project before these options can be displayed You must make recommendation to accept or reject the project before thes ptions can be displayed. You must make a recommendation to accept or reject the project before these options can be displayed. You must make a ptions can be displayed. You must make a recommendation to accept or reject the project before these options can be displayed. You must make a ptions can be displayed. You must make a recommendation to accept or ject before these options can be displayed. You must make a r nese options can be displayed. You must make a recommendation to accept or reject the project before these options can be displayed.H13 X V fx ABC D G H I J K 10 Go www.ato.gov.au In the Search box at the top of the screen, enter 'Company tax rates' and click the magnifying glass. You may need to click on more than one link to figure out the appropriate tax rate for Melbourne. Enter the company tax rate for this company for the 2019/20 tax year (as a percentage) in the box below. 11 12 (Hint: Melbourne's turnover is over $50 million.) 13 Melbourne's tax rate: 14 15 2. Find the yield on 9-year and 10-year Australian Treasury bonds. 16 Goto www.rba.gov.au Click on "Statistics" near the top of the page, and then, under the subheading "Economic and Financial Statistics", click on "Interest Rates" (Depending on your browser, you may then have to scroll up until you see the Interest Rates section.) Click on the "XLS" link to open the spreadsheet containing "Indicative Mid Rates of Commonwealth Government Securities - F16". 17 This spreadsheet contains daily yield data for Australian Treasury bonds on issue on a given date. Each column conains yields for a specific bond. Each row contains the yields for each bond for a given date - the date shown in Column A. Scroll down to find the yields on 18 March 2021. 18 Row 3 of the RBA spreadsheet contains the maturity date of each bond. Search along Row 3 to find the column containing the bond that is closest to maturing 10 years from 18 March 2021. If you find that the date that is 10 years from 18 March 2021 falls between two maturity dates (which it almost certainly will), make sure you select the bond that will have MOST RECENTLY MATURED on that date - not the one that will next mature after that date. Make sure you are looking up yields for "Treasury Bonds", as specified in Row 2. If the entry in Row 2 says "Treasury Indexed Bonds", you have gone too far. 19 Then go down that column to find the yield as at 18 March 2021. The value you see is the yield on 10-year Australian Treasury bonds on 18 March 2021, which we will use as the risk-free rate in the Capital Asset Pricing Model in Part 1 of the Assignment. Enter the 10-year risk-free rate in the box below (as a 20 percentage to 3 decimal places). 21 10-year risk-free rate: 22 Search along Row 3 of the RBA spreadsheet to find the column containing the bond that is closest to maturing 9 years from 18 March 2021 Again, if the date that is 9 years from 18 March 2021 falls between two maturity dates, select the bond that will have most recently matured on that date - not the bond that will next mature after that date. Then go down that column to find the yield for that bond as at 18 March 2021. In Part 1 you will add the credit spread for Melbourne's bonds to the 9-year risk-free rate to determine the before-tax cost of the company's bonds. Enter the 9-year risk-free rate in the box below (as 23 a percentage to 3 decimal places). 25 9-year risk-free rate:C4 X V fox Project Information Project Information The equipment will cost $680, is expected to have a working life of 4 years, and will be depreciated on a straight-line basis to a book value of zero. The equipment is expected to have a salvage value of $180 at the end of 4 years. The new equipment will improve efficiency and result in increased revenue of $870 in its first year of operation, but because of reduced efficiency from normal wear and tear, revenue will decrease by 3% (from the previous year's revenue) for each of the remaining 3 years of the equipment's life. Excluding maintenance, all other costs from operating the equipment will be $260 per year. Maintenance costs will amount to $140 in the equipment's first year of operation, and will then increase by $20 per year for the remaining 3 years of the equipment's life. The equipment will require additional net working capital of $190. The net working capital will be recovered in full after the equipment is sold at the end of its working life. The equipment will be installed in a building that is owned by the company, but currently is not being used. If the project does not proceed, this building could be rented out for $190 per year. A feasibility study has been undertaken into the purchase of the new equipment. The cost of preparing the feasibility study was $200. The company has sufficient capital to undertake all positive-NPV projects. If the Payback Period method is used to evaluate projects, management's policy is that the maximum acceptable payback period is 3 years, and all cash flows in Year 0 would need to be recovered within 3 years for the project to be acceptable under this method.B2 X V fx Rating Rating 1 yr 2 yr B yr 4 yr 5 yr 6 yr 7 yr AAA 126 8 yr 9 yr 156 10 yr 186 216 246 276 AA+ 306 135 336 165 366 195 225 396 255 285 AA 315 144 345 174 375 204 234 405 264 294 AA- 324 153 354 183 213 384 414 243 273 303 A+ 333 162 363 192 222 393 252 423 282 312 342 A 171 201 372 231 402 261 432 291 321 A- 351 180 381 210 411 240 441 270 300 330 BBB+ 360 189 219 390 420 249 450 279 309 339 BBB 369 198 228 399 429 258 459 288 318 348 BBB- 378 408 207 237 438 267 468 297 327 357 BB+ 387 216 246 417 276 447 477 306 336 366 BB 396 225 426 255 456 285 486 315 345 375 BB- 405 234 264 435 465 294 324 495 354 384 B+ 414 243 444 273 474 303 333 504 363 393 B 423 252 282 453 312 483 342 513 372 402 B- 432 261 462 291 321 492 351 522 381 411 441 CCC+ 270 471 300 330 501 531 360 390 420 CCC 450 279 480 309 510 339 540 369 399 429 CCC- 459 288 489 318 348 519 549 378 408 438 CC 468 297 498 327 528 357 558 387 417 447 C 477 306 336 507 366 537 567 396 426 456 486 516 546 576Balance Sheet as at 31/12/20 ASSETS LIABILITIES Notes Cash 150 Accounts payable 130 Accounts Receivable 180 Bank loan (interest only) 1 250 Inventory 610 Mortgage Loan 2 510 Property, plant & equipment 1,280 Corporate bonds 3 340 Total Assets 2,220 Total liabilities 1,230 SHAREHOLDERS' EQUITY Ordinary shares 4 450 Preference Shares 5 250 Retained earnings 290 Total shareholders' equity 990 Total liabilities and shareholders' equity 2,220 Notes 1. The interest rate on the bank loan is 8.6% p.a. 2. The interest rate on the mortgage loan is 5.8% p.a. 3. The corporate bonds have a credit rating of A and have 9 years to maturity. They make semi-annual coupon payments at a coupon rate of 7% p.a. The ordinary shares are shown on the balance sheet at their book value of $1 per share. They have a beta of 1.9. They are expected to pay a dividend of $0.05 next year. The dividend is expected to grow at a rate of 7% p.a. for the following 4 years, and after that it will grow at a constant rate of 3% p.a. in perpetuity. The preference shares have a par value of $1 each and are shown on the Balance Sheet at their par value. They pay a constant dividend of $0.11 and they are currently trading for $1.09. The risk premium for the ordinary shares is 8.7%
