QUESTION:
Hawthorn Manufacturing Company Ltd Balance Sheet as at 31/12/19 Notes ASSETS Cash Accounts Receivable Inventory Property, plant & equipment LIABILITIES Accounts payable Bank loan (interest only) Mortgage Loan Corporate bonds 150 200 640 1.120 1 130 200 500 310 w N Total Assets 2.110 Total liabilities 1.140 SHAREHOLDERS' EQUITY Ordinary shares 4 Preference Shares Retained earnings Total shareholders' equity Total liabilities and shareholders' equity 450 230 290 970 2.110 Notes 1. 2. The interest rate on the bank loan is 8,2% p.a. The interest rate on the mortgage loan is 5,2% p.a. The corporate bonds have a credit rating of AAA and have 2 years to maturity. They make semi-annual coupon payments at a coupon rate of 5% p.a. 3. 4. 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 have just paid a dividend of $000. The dividend is expected to grow at a rate of 9% p.a. for the next 3 years, and after that it will grow at a constant rate of 3% p.a. in perpetuity. 5. 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 $000 and they are currently trading for $1,02. 6. The market risk premium is 10%. 1 2 4 5 6 8 9 10 313 323 333 343 353 363 373 Rating AAA AA+ AA AA- + A - BBB+ BBB- BB+ BB- + B - + - 127 137 147 157 167 177 187 197 207 217 227 237 247 257 267 277 287 297 307 317 327 158 168 178 188 198 208 218 228 238 248 258 268 278 288 298 308 318 328 338 348 358 3 189 199 209 219 229 239 249 259 269 279 289 299 309 319 329 339 349 359 369 379 389 220 230 240 250 260 270 280 290 300 310 320 330 340 350 360 370 380 390 400 410 420 251 261 271 281 291 301 311 321 331 341 351 361 371 381 391 401 411 421 431 441 451 282 292 302 312 322 332 342 352 362 372 382 392 402 412 422 432 442 452 462 472 482 383 393 403 413 423 433 443 453 463 344 354 364 374 384 394 404 414 424 434 444 454 464 474 484 494 504 514 524 534 544 375 385 395 405 415 425 435 445 455 465 475 485 495 505 515 525 535 545 555 565 575 406 416 426 436 446 456 466 476 486 496 506 516 526 536 546 556 566 576 586 596 606 473 483 493 503 513 The equipment will cost $700, is expected to have a working life of 4 years, and will be depreciated on a diminishing-value basis to a book value of zero. The equipment is expected to have a salvage value of $140 at the end of 4 years. The new equipment will improve efficiency and result in increased revenue of $810 in its first year of operation, but because of reduced efficiency from normal wear and tear, revenue will decrease by 7% (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 $100 in the equipment's first year of operation, and will then increase by $30 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 $500. 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. PART 2 - PROJECT EVALUATION 2 3 4 WACC: II Year Opening Book Value less Depreciation Closing Book Value Tax Rate: Round off all dollar values below to the nearest whole number. All expenses and cash outflows must be negative numbers. Revenue and expenses (Read the important Note to the right.) 2 3 0 Incremental EBIT less Tax Incremental Earnings 0 0 0 0 Other cash flows (The Important Note also applies.) N 3 4 5 Incremental Free Cash Flows 0 0 0 0 0 D NPV Payback Period years Or tick this bois the outlay is never recovered. IRR 100 Profitability Index Should the project be accepted? (Enter YES or NO in capital letters) Why/why not? Please select all of the following that apply. Hawthorn Manufacturing Company Ltd Balance Sheet as at 31/12/19 Notes ASSETS Cash Accounts Receivable Inventory Property, plant & equipment LIABILITIES Accounts payable Bank loan (interest only) Mortgage Loan Corporate bonds 150 200 640 1.120 1 130 200 500 310 w N Total Assets 2.110 Total liabilities 1.140 SHAREHOLDERS' EQUITY Ordinary shares 4 Preference Shares Retained earnings Total shareholders' equity Total liabilities and shareholders' equity 450 230 290 970 2.110 Notes 1. 2. The interest rate on the bank loan is 8,2% p.a. The interest rate on the mortgage loan is 5,2% p.a. The corporate bonds have a credit rating of AAA and have 2 years to maturity. They make semi-annual coupon payments at a coupon rate of 5% p.a. 3. 4. 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 have just paid a dividend of $000. The dividend is expected to grow at a rate of 9% p.a. for the next 3 years, and after that it will grow at a constant rate of 3% p.a. in perpetuity. 5. 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 $000 and they are currently trading for $1,02. 6. The market risk premium is 10%. 1 2 4 5 6 8 9 10 313 323 333 343 353 363 373 Rating AAA AA+ AA AA- + A - BBB+ BBB- BB+ BB- + B - + - 127 137 147 157 167 177 187 197 207 217 227 237 247 257 267 277 287 297 307 317 327 158 168 178 188 198 208 218 228 238 248 258 268 278 288 298 308 318 328 338 348 358 3 189 199 209 219 229 239 249 259 269 279 289 299 309 319 329 339 349 359 369 379 389 220 230 240 250 260 270 280 290 300 310 320 330 340 350 360 370 380 390 400 410 420 251 261 271 281 291 301 311 321 331 341 351 361 371 381 391 401 411 421 431 441 451 282 292 302 312 322 332 342 352 362 372 382 392 402 412 422 432 442 452 462 472 482 383 393 403 413 423 433 443 453 463 344 354 364 374 384 394 404 414 424 434 444 454 464 474 484 494 504 514 524 534 544 375 385 395 405 415 425 435 445 455 465 475 485 495 505 515 525 535 545 555 565 575 406 416 426 436 446 456 466 476 486 496 506 516 526 536 546 556 566 576 586 596 606 473 483 493 503 513 The equipment will cost $700, is expected to have a working life of 4 years, and will be depreciated on a diminishing-value basis to a book value of zero. The equipment is expected to have a salvage value of $140 at the end of 4 years. The new equipment will improve efficiency and result in increased revenue of $810 in its first year of operation, but because of reduced efficiency from normal wear and tear, revenue will decrease by 7% (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 $100 in the equipment's first year of operation, and will then increase by $30 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 $500. 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. PART 2 - PROJECT EVALUATION 2 3 4 WACC: II Year Opening Book Value less Depreciation Closing Book Value Tax Rate: Round off all dollar values below to the nearest whole number. All expenses and cash outflows must be negative numbers. Revenue and expenses (Read the important Note to the right.) 2 3 0 Incremental EBIT less Tax Incremental Earnings 0 0 0 0 Other cash flows (The Important Note also applies.) N 3 4 5 Incremental Free Cash Flows 0 0 0 0 0 D NPV Payback Period years Or tick this bois the outlay is never recovered. IRR 100 Profitability Index Should the project be accepted? (Enter YES or NO in capital letters) Why/why not? Please select all of the following that apply
