ACCT222 Intermediate Accounting Project Assignment

Reference no: EM132487931

ACCT222 Intermediate Accounting Project Assignment - Qatar University, Qatar

One of the learning 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 Company issued a 55 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 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.

REQUIREMENTS -

Step One: Collect and input the data related to the available investment opportunities

By using an Excel spreadsheet, you are required to design an electronic table with 6 independent columns as follow:

Period

Interest Payment

Interest Revenue

Discount Amortization Or Premium

Unamortized Discount Or Premium

Carrying Value

Step Two: Data analysis by using electronic tables (e-tables)

Prepare an electronic table (e-table) for each investment opportunity.

Calculate all the values in all the columns using Excel PV Function.

Step Three: Take the necessary investment decision

You have to compare the obtained data analysis for the e-tables related to each investment opportunities. Then, you need to take the appropriate investment decision by selecting one the investment opportunities (You have to learn and understand how choose an investment over other investments by using accounting).

Step Four: Prepare a report based on the obtained accounting data produced by the data analysis

Prepare a report (two pages maxim um) that clearly indicates the results you obtained from your evaluation of the two investment opportunities and ta king particularly into account the future cash inflows or outflows of each investment separately, under the following assumptions:

1- The sale of the bond issued by Qatar Modern Electronics Company by the end of 2022 for a sum of $42,250,000.

2- The sale of bond issued by Qatar International Trade Company by the end of 2027 for a sum of $53,750,000.

Submit two documents: The Excel document of your analysis and PDF file including your report.

Reference no: EM132487931

Questions Cloud

What is the probability that a transmitted digit : What is the probability that a transmitted digit is correctly received by the satellite?

Data and the standard deviation for discrete data : What is the difference between the standard deviation for Continuous data and the standard deviation for Discrete data?

What is the IRR from the investment in the bonds : What is the IRR from the investment in the bonds? A firm purchases Treasury bonds for $250,000. The Face Value of the bonds are $300,000.

Perform the formal statistical test : Should the consumer agency doubt the manufacturer's claim that the mean mileage is 55,000 km? Perform the formal statistical test using a 5% level

ACCT222 Intermediate Accounting Project Assignment : ACCT222 Intermediate Accounting Project Assignment Help and Solutions - Qatar University, Qatar. Prepare a report based on the obtained accounting data

Determine the probability that a customer service time : Consider an M/M/1 queueing system in which the expected waiting time and expected number of customers in the system are 120 minutes and 10 customers

Give an operational definition for problem : Give an operational definition for problem. Why is the operational definition important in interpreting the initial quality score?

Determine the expected price of gasoline per gallon : Arriving customers always wait until they can eventually buy gasoline. Determine the expected price of gasoline per gallon.

Discuss what you intend to study or assess : In a 1-2 page paper, identify an assessment tool and discuss what you intend to study or assess. Be sure to proofread your work to eliminate spelling.

User Account

All Pages