Please for the excel document can you add the details and the equation you used to reach to the result. And for the report I hope it is clear and easy to understand. Regards
ACCT222 INTERMEDIATE ACCOUNTING 2 INFORMATION TECHNOLOGY PROJECT (SPRING 2019) One of the leaming outcome related to Intermediate Accounting 2 is to enable the students to utilize information technology in financial decision making. Within this perspective, you are required to fulfil the following requirements 1. Collect and input the information related to the available investment opportunities 2. Analyze the information by using Excel spreadsheets (e-tables) 3. Take the appropriate investment decision. 4. Produce a report based on the accounting information produced by the data analysis performed in requirement 3 Available investments opportunities Assume that you have been hired as an accountant in Al Barakah Financial Intermediation Company. Part of your duties in your new position is managing and reporting about one the of investment portfolios of the company. Consequently, you have to deal with two of the investment opportunities. Investment opportunity One In 1.1.2016 Qatar Modern Electronics Company issued a 42 million dollars 10% bond as a long term investment. Assume that Al Barakah management has the intent and the positive ability to keep these bonds until maturity (December 31, 2025). For bonds of similar risk and maturity, the market yield was 8%. Interest is received semiannually on June 30 and December 31 for all the years, till maturity Investment opportunity Two In 1.1.2016 Qatar International Trade Com long term investment. Assume that Al Barakah management has the intent and the positive ability to keep these bonds till maturity (December 31, 2030). Management has the positive intent and ability to hold the bonds until maturity. For bonds of similar risk and maturity the market yield was 12%. Interest is received semiannually on June 30 and December 31 for all the years, till maturity pany issued a 55 million dollars 10% bond as a ACCT222 INTERMEDIATE ACCOUNTING 2 INFORMATION TECHNOLOGY PROJECT (SPRING 2019) One of the leaming outcome related to Intermediate Accounting 2 is to enable the students to utilize information technology in financial decision making. Within this perspective, you are required to fulfil the following requirements 1. Collect and input the information related to the available investment opportunities 2. Analyze the information by using Excel spreadsheets (e-tables) 3. Take the appropriate investment decision. 4. Produce a report based on the accounting information produced by the data analysis performed in requirement 3 Available investments opportunities Assume that you have been hired as an accountant in Al Barakah Financial Intermediation Company. Part of your duties in your new position is managing and reporting about one the of investment portfolios of the company. Consequently, you have to deal with two of the investment opportunities. Investment opportunity One In 1.1.2016 Qatar Modern Electronics Company issued a 42 million dollars 10% bond as a long term investment. Assume that Al Barakah management has the intent and the positive ability to keep these bonds until maturity (December 31, 2025). For bonds of similar risk and maturity, the market yield was 8%. Interest is received semiannually on June 30 and December 31 for all the years, till maturity Investment opportunity Two In 1.1.2016 Qatar International Trade Com long term investment. Assume that Al Barakah management has the intent and the positive ability to keep these bonds till maturity (December 31, 2030). Management has the positive intent and ability to hold the bonds until maturity. For bonds of similar risk and maturity the market yield was 12%. Interest is received semiannually on June 30 and December 31 for all the years, till maturity pany issued a 55 million dollars 10% bond as a
