This is the first part of the assignemt, its worth a small percentage of my grade but the class and myself are confused about what to do. Please help!

Sorry about that. Here are links to the photos so you can see them clearly. All in order. Thanks again!

https://ibb.co/MP2G3PX

https://ibb.co/68shntq

https://ibb.co/qjfSqSM

https://ibb.co/Q8Dkcvg

https://ibb.co/3MPsq2X

12 Home Insert Drow View P 4 Font Agent Number 029 acreditating of VLOOKUP Studio, Duta, HINO FUNDAMENTALS GEHANGE ASSMENT Sydney Manufacturing Company Ltd Balance Sheet as at 31/12/19 ASSETS Accounts Receivable Inventory Property, plant & equipment 110 210 500 L120 Bronson More Corporate bonds 2 3 110 250 530 350 Total Assets 2.0 1,230 SHOESQUITY Oyshares 400 29 Tattarakattary Total shareholders' equity 2,000 1. The interest rate on the bank loan is 2 The interest rate on the mortgage loan is SIA 1. The corporate bonds have a credit rating of and have years to maturity. They make quarterly coupon payments at a coupon rate of inpa 4. The ordinary shares are shown on the balance sheet at the book value of super share. They have a beta of L. They are expected to pay a dividend of $0.0 year. The dividend is expected to grow at a rate of .. for the following years, and other that it willow constant rate of pain perpetuity, 5. The preference shares have a per value of each and we shown on the Balance Sheet at the per value They say a constant dividend of 0.11 and they are coming for $1.01. The expected return on the market is. - Font Alignment Number Editing Ideas Clipboard HID 30N Online Data Follow the instructions below to locate online detailed Anment Read intruction on this very carefully.dometect the requested data The Instructions on this pe tell you exactly whate de with the data when completing the other party Assement 1. Determine Sydney's tax rate Go www. 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 Sydney. Enter the company tax rate for this company for the 2019/20 tax year as a percentage In the box below Hint Sydney's turnover is over 50 million) Sydney's tax rate 30.0% 2. Find the yield on 4-year and 10-year Australian Treasury bonds. Got ... Click on "Statistics near the top of the pape, 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 link to open the spreadsheet containing indicative Mid Rates of Commonwealth Government Securities - F16. This spreadsheet contains daily yield data for Australian Treasury bonds on issue on appen date. Each column consins 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 28 July 2020 Row 3 of the RSA spreadsheet contains the maturity date of each bond Search along Row 3 to find the column containing the bond that is closest touring 10 years from 28 July 2020 you find that the date that is 10 years from 28 2020 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 mature her that date. Make sure you are looking up yields for "Treasury Bonds", as specified in Row 2. of the entry in Row 2 says "Treasury Indexed Bonds". you have gone too far Then go down that column to find the yield as at 28 2020. The value you see is the vield on 10-year Australian Treasury bonds on 28 July 2020, 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 las a percentage to 3 decimal places 10 year risk-free rate: Search along Row 3 of the RBA spreadsheet to find the column containing the bond that is closest to maturing 4 years from 28 July 2020 Again, if the date that is 4 years from 28 July 2020 falls between two maturity dates, select the bond will have most recently matured on that date not the bond that will next mature her that date. Then go down that column to find the yield for that bond as at 28 July 2020. In Part I you will add the credit spread for Sydney's bonds to the year risk-free rate to determine the before tax cost of the company's bonds Enter the 4-year risk free rate in the box below as a percentage to 3 decimal places) 2 f Rating 1 2 3 8 yr 127 136 145 154 163 5 yr 263 272 281 290 299 308 317 326 172 Rating AA+ A+ - BBB+ BBB- BB+ BB- + B- CCC+ ccc - 181 190 199 208 217 226 235 244 253 262 271 335 161 170 179 188 197 206 215 224 233 242 251 260 269 278 287 296 305 314 323 332 341 195 204 213 222 231 240 249 258 267 276 285 294 303 312 321 330 339 348 357 4 229 238 247 256 265 274 283 292 301 310 319 328 337 346 355 364 373 382 391 400 409 6 297 306 315 324 333 342 351 360 369 378 387 396 405 414 423 432 365 374 383 392 401 410 419 428 437 446 455 464 473 482 491 7 yr 331 340 349 358 367 376 385 394 403 412 421 430 439 448 457 466 475 484 493 502 511 344 353 362 371 380 389 398 407 416 425 434 443 9 399 408 417 426 435 444 453 462 471 480 489 498 507 516 525 534 543 552 561 570 579 10 433 442 451 460 469 478 407 496 505 514 S23 S32 S41 550 559 568 577 586 595 604 613 500 441 280 289 298 307 509 518 527 536 545 450 459 468 477 366 375 FIFOF File D Page Layout Formas Data View Help B Ali Nu pad Project Information FIN1FOF- FUNDAMENIMSONCE ASSIGNMENT Project Information The equipment will cost $740, is expected to have a working life of 4 years, and will be deprecated on a diminishing value basis to a book value of zero. The equipment is expected to have a salvage value of $150 at the end of 4 years. The new equipment will improve efficiency and result in increased revenue of 5870 in its first year of operation, but because of reduced efficiency from normal wear and tear, revenue will decrease by 8% [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 $220 per year. Maintenance costs will amount to $110 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 networking capital of $110. 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 $110 per year. A feasibility study has been undertaken into the purchase of the new equipment. The cost of preparing the feasibility study was $300 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 O would need to be recovered within 3 years for the project to be acceptable under this method. NO COST VALUE WLIGH T SOURCE OF CAPITAL Bank Loan interest only! Before-tecost of barn Mortgage Loans Before-cortof mortgage loan Market value of mortgage loan Corporate Bonds Credit spread Credit spread as a percentage decimal placed cost of corpore bonds decimal places Before-tax cost of corporate bonds Face value of albonde Coupon rate Number of stoma Number of coupon payment per Total number of coupon presenning Toral value of a coupon payments paldperye Value of each individual coupon Quarterly yield 13 decimal places Value of corporate bonds Ordinary Shares Piskrewe to be used to calore cost of ordinary shares decimal places Beta Expected on the market Cost of ordinary shares we hawa the shape Dividend 1year from now Dividend 2 years from now Dividend 3 years from now Dividend 4 years from now Dividend 5yearshom now Dividend ye som now Price of ordinary thwes Pound to 2 decimal Number of ordinary shares Total metal of ordinary shares Preference Shares Preference dividend per share Preference the price Costo preference there Number of reference thwes Toralmaketako preference shares SO Tax Rate Aletheid.com bbould be Weighred Cost of the Bank Loan Costnega Weigleed Cost of the Mortgage Loan Wegled Cost of the Corporate Bonds Weighed Cost the Ordinary Shares Weighted Cost of the Preference Shwres Weighted Average Cost of Capital 12 Home Insert Drow View P 4 Font Agent Number 029 acreditating of VLOOKUP Studio, Duta, HINO FUNDAMENTALS GEHANGE ASSMENT Sydney Manufacturing Company Ltd Balance Sheet as at 31/12/19 ASSETS Accounts Receivable Inventory Property, plant & equipment 110 210 500 L120 Bronson More Corporate bonds 2 3 110 250 530 350 Total Assets 2.0 1,230 SHOESQUITY Oyshares 400 29 Tattarakattary Total shareholders' equity 2,000 1. The interest rate on the bank loan is 2 The interest rate on the mortgage loan is SIA 1. The corporate bonds have a credit rating of and have years to maturity. They make quarterly coupon payments at a coupon rate of inpa 4. The ordinary shares are shown on the balance sheet at the book value of super share. They have a beta of L. They are expected to pay a dividend of $0.0 year. The dividend is expected to grow at a rate of .. for the following years, and other that it willow constant rate of pain perpetuity, 5. The preference shares have a per value of each and we shown on the Balance Sheet at the per value They say a constant dividend of 0.11 and they are coming for $1.01. The expected return on the market is. 12 Home Insert Drow View P 4 Font Agent Number 029 acreditating of VLOOKUP Studio, Duta, HINO FUNDAMENTALS GEHANGE ASSMENT Sydney Manufacturing Company Ltd Balance Sheet as at 31/12/19 ASSETS Accounts Receivable Inventory Property, plant & equipment 110 210 500 L120 Bronson More Corporate bonds 2 3 110 250 530 350 Total Assets 2.0 1,230 SHOESQUITY Oyshares 400 29 Tattarakattary Total shareholders' equity 2,000 1. The interest rate on the bank loan is 2 The interest rate on the mortgage loan is SIA 1. The corporate bonds have a credit rating of and have years to maturity. They make quarterly coupon payments at a coupon rate of inpa 4. The ordinary shares are shown on the balance sheet at the book value of super share. They have a beta of L. They are expected to pay a dividend of $0.0 year. The dividend is expected to grow at a rate of .. for the following years, and other that it willow constant rate of pain perpetuity, 5. The preference shares have a per value of each and we shown on the Balance Sheet at the per value They say a constant dividend of 0.11 and they are coming for $1.01. The expected return on the market is. - Font Alignment Number Editing Ideas Clipboard HID 30N Online Data Follow the instructions below to locate online detailed Anment Read intruction on this very carefully.dometect the requested data The Instructions on this pe tell you exactly whate de with the data when completing the other party Assement 1. Determine Sydney's tax rate Go www. 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 Sydney. Enter the company tax rate for this company for the 2019/20 tax year as a percentage In the box below Hint Sydney's turnover is over 50 million) Sydney's tax rate 30.0% 2. Find the yield on 4-year and 10-year Australian Treasury bonds. Got ... Click on "Statistics near the top of the pape, 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 link to open the spreadsheet containing indicative Mid Rates of Commonwealth Government Securities - F16. This spreadsheet contains daily yield data for Australian Treasury bonds on issue on appen date. Each column consins 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 28 July 2020 Row 3 of the RSA spreadsheet contains the maturity date of each bond Search along Row 3 to find the column containing the bond that is closest touring 10 years from 28 July 2020 you find that the date that is 10 years from 28 2020 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 mature her that date. Make sure you are looking up yields for "Treasury Bonds", as specified in Row 2. of the entry in Row 2 says "Treasury Indexed Bonds". you have gone too far Then go down that column to find the yield as at 28 2020. The value you see is the vield on 10-year Australian Treasury bonds on 28 July 2020, 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 las a percentage to 3 decimal places 10 year risk-free rate: Search along Row 3 of the RBA spreadsheet to find the column containing the bond that is closest to maturing 4 years from 28 July 2020 Again, if the date that is 4 years from 28 July 2020 falls between two maturity dates, select the bond will have most recently matured on that date not the bond that will next mature her that date. Then go down that column to find the yield for that bond as at 28 July 2020. In Part I you will add the credit spread for Sydney's bonds to the year risk-free rate to determine the before tax cost of the company's bonds Enter the 4-year risk free rate in the box below as a percentage to 3 decimal places) 2 f Rating 1 2 3 8 yr 127 136 145 154 163 5 yr 263 272 281 290 299 308 317 326 172 Rating AA+ A+ - BBB+ BBB- BB+ BB- + B- CCC+ ccc - 181 190 199 208 217 226 235 244 253 262 271 335 161 170 179 188 197 206 215 224 233 242 251 260 269 278 287 296 305 314 323 332 341 195 204 213 222 231 240 249 258 267 276 285 294 303 312 321 330 339 348 357 4 229 238 247 256 265 274 283 292 301 310 319 328 337 346 355 364 373 382 391 400 409 6 297 306 315 324 333 342 351 360 369 378 387 396 405 414 423 432 365 374 383 392 401 410 419 428 437 446 455 464 473 482 491 7 yr 331 340 349 358 367 376 385 394 403 412 421 430 439 448 457 466 475 484 493 502 511 344 353 362 371 380 389 398 407 416 425 434 443 9 399 408 417 426 435 444 453 462 471 480 489 498 507 516 525 534 543 552 561 570 579 10 433 442 451 460 469 478 407 496 505 514 S23 S32 S41 550 559 568 577 586 595 604 613 500 441 280 289 298 307 509 518 527 536 545 450 459 468 477 366 375 FIFOF File D Page Layout Formas Data View Help B Ali Nu pad Project Information FIN1FOF- FUNDAMENIMSONCE ASSIGNMENT Project Information The equipment will cost $740, is expected to have a working life of 4 years, and will be deprecated on a diminishing value basis to a book value of zero. The equipment is expected to have a salvage value of $150 at the end of 4 years. The new equipment will improve efficiency and result in increased revenue of 5870 in its first year of operation, but because of reduced efficiency from normal wear and tear, revenue will decrease by 8% [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 $220 per year. Maintenance costs will amount to $110 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 networking capital of $110. 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 $110 per year. A feasibility study has been undertaken into the purchase of the new equipment. The cost of preparing the feasibility study was $300 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 O would need to be recovered within 3 years for the project to be acceptable under this method. NO COST VALUE WLIGH T SOURCE OF CAPITAL Bank Loan interest only! Before-tecost of barn Mortgage Loans Before-cortof mortgage loan Market value of mortgage loan Corporate Bonds Credit spread Credit spread as a percentage decimal placed cost of corpore bonds decimal places Before-tax cost of corporate bonds Face value of albonde Coupon rate Number of stoma Number of coupon payment per Total number of coupon presenning Toral value of a coupon payments paldperye Value of each individual coupon Quarterly yield 13 decimal places Value of corporate bonds Ordinary Shares Piskrewe to be used to calore cost of ordinary shares decimal places Beta Expected on the market Cost of ordinary shares we hawa the shape Dividend 1year from now Dividend 2 years from now Dividend 3 years from now Dividend 4 years from now Dividend 5yearshom now Dividend ye som now Price of ordinary thwes Pound to 2 decimal Number of ordinary shares Total metal of ordinary shares Preference Shares Preference dividend per share Preference the price Costo preference there Number of reference thwes Toralmaketako preference shares SO Tax Rate Aletheid.com bbould be Weighred Cost of the Bank Loan Costnega Weigleed Cost of the Mortgage Loan Wegled Cost of the Corporate Bonds Weighed Cost the Ordinary Shares Weighted Cost of the Preference Shwres Weighted Average Cost of Capital 12 Home Insert Drow View P 4 Font Agent Number 029 acreditating of VLOOKUP Studio, Duta, HINO FUNDAMENTALS GEHANGE ASSMENT Sydney Manufacturing Company Ltd Balance Sheet as at 31/12/19 ASSETS Accounts Receivable Inventory Property, plant & equipment 110 210 500 L120 Bronson More Corporate bonds 2 3 110 250 530 350 Total Assets 2.0 1,230 SHOESQUITY Oyshares 400 29 Tattarakattary Total shareholders' equity 2,000 1. The interest rate on the bank loan is 2 The interest rate on the mortgage loan is SIA 1. The corporate bonds have a credit rating of and have years to maturity. They make quarterly coupon payments at a coupon rate of inpa 4. The ordinary shares are shown on the balance sheet at the book value of super share. They have a beta of L. They are expected to pay a dividend of $0.0 year. The dividend is expected to grow at a rate of .. for the following years, and other that it willow constant rate of pain perpetuity, 5. The preference shares have a per value of each and we shown on the Balance Sheet at the per value They say a constant dividend of 0.11 and they are coming for $1.01. The expected return on the market is