Question

In: Accounting

Question1 1.1Complete the table Tracey started a business. During the first month the following transactions occurred....

Question1

1.1Complete the table

Tracey started a business. During the first month the following transactions occurred.

  1. She opened a bank account for the business and deposited a cheque for the amount of R950 000.
  2. The business bought a property R450 000 (R250 000 loan and cash R200 000).
  3. Business bought stock for R120 000 cash.
  4. Stock was sold for R100 000 cash, which cost R60 000.
  5. Business is owing Telkom R24 000.

Example: Bought a truck for R200 000 cash

+ 200K (Non-current asset or NCA) and -200K Bank : You are required to show the signs.

Assets   =                                                         

Owner’s equity     +

   Liabilities

1

2

3

4

5

Total

1.2 Nayika Ltd is in the process of analysing a project which they call Project Extend. The relevant cash flows for the project are shown in the table below. Nayika’s cost of capital is 13%. Complete the table and show basic workings after the questions

Project Extend

Factor

PV amount

Initial Investment

R1000 000

Year

Cash Inflows(Rands)

1

    180 000

2

    200 000

3

           380 000

4

   490 000

5

    250 000

Total

  1. Calculate the project payback period.(in years and months)                                                 
  2. Calculate the net present value (NPV) of the project   .
  3. Explain whether the project should be accepted?

Solutions

Expert Solution

Q1

S.no Assets = +Owners equity Liabilities
1 +950,000 (Bank) +950,000
2 +450,000( NCA) and -200,000 cash +250,000 loan
3 +120,000 (stock) and -120,000 cash
4 -60,000(stock) and +100,000 cash +40,000(Profit)
5 -24,000 +24,000 (outstanding liability)
Total 1,240,000 966,000 274,000

Total assets = Owner's equity + liabilities

1,240,000 = 966,000 + 274,000

Explanation

1 - Owner opened a bank account for the business - Asset increased, Owners equity increased

2 - Bought a property for cash and loan - Asset increased by equipment value and decreased by cash spent, Liability increased by the loan amount

3 - Stock bought for cash - Asset increased and decreased by the same amount

4 - Stock was sold for more than its cost for cash - Asset decreased by stock vale and increased by the cash received, owners equity increased by the profit earned

5 - Business owed - Outstanding payable - liability increased, Owners equity decresed by the same amount

Q2

a) Calculate the project payback period.(in years and months)

Year Net cash flow Inflow Cumulative cash inflows
1 +180,000 180,000
2 +200,000 380,000
3 +380,000 760,000
4 +490,000 1,250,000
5 +250,000 1,500,000

Payback period = 3 years + (240,000 / 490,000) (1000,000 - 760,000 = 240,000 )

= 3 + 0.49 OR 3.5 years

= 3 years 6 months

b) Calculate the net present value (NPV) of the project?

Expected cashflows = $180,000 will be received at the end of the first year, $200,000 at the end of the second year, $380,000 at the end of the third year, $490,000 at the end of the fourth year, and $250,000 at the end of the fifth year. Let’s find the present value of the cash flow stream if the discount rate is 13%

The present value of the first cash flow (CF1) amounts to $159,292, CF2 is $156,629, CF3 is $263,359, CF4 is $300,526, and CF5 is $135,690.

PV of CF1 = $180,000 ÷ (1 + 0.13)1 = $159,292

PV of CF2 = $200,000 ÷ (1 + 0.13)2 = $156,629

PV of CF3 = $380,000 ÷ (1 + 0.13)3 = $263,359

PV of CF4 = $490,000 ÷ (1 + 0.13)4 = $300,526

PV of CF5 = $250,000 ÷ (1 + 0.13)5 = $135,690

Thus, the present value of the uneven cash flow stream will be $1,015,496.

Net present value = Present value of cash inflows - initial invesment

= $1,015,496 - $1,000,000

=$15,496

C)  The project should be accepted as it has a smaller payback period of 3.5 years which is less than the project overall life of 5 years and a positive net present value of $15,496.


Related Solutions

Maya started her business on July 1, 2020. The following transactions occurred during the month of...
Maya started her business on July 1, 2020. The following transactions occurred during the month of July. Identify the effects of the following transactions on the accounting equation: July Transactions 1 Maya started her agriculture business with RM150,000 cash. 3 Paid RM1,000 in the month for rent of office space. 4 Purchased RM1,500 chemicals on credit terms from BioLogic Company. 5 Paid RM700 for publicity in the Malaysia Business newspaper. 8 Interviewed candidates who applied for a marketing executive position...
The following transactions occurred in the first month of the business operation: No Transactions Effect on...
The following transactions occurred in the first month of the business operation: No Transactions Effect on Assets Liabilities Equity Example Commission received, RM200 Increase Increase 1 Introduced capital of RM50,000 cash into the business. 2 Withdrew RM500 cash to pay for his mother’s medical bills. 3 Bought a van on credit RM70,000 from Proton. 4 Customer paid the business RM6,300. 5 The business pay supplier RM2,700 through online banking. 6 Repaid a RM780 loan owed to Robert by cash. 7...
Business Events and Transactions for September 2019: The following transactions occurred during the first week of...
Business Events and Transactions for September 2019: The following transactions occurred during the first week of September. • September 1- Pay the $3,175 August interest owed to the bank. Also make a $40,000 payment on the bank note principal. • September 1- The company purchased office supplies for the first time in September. They purchased $2,400 in supplies from Office Depot and paid for it in cash. • September 5- the company has collected $225,000 in cash on the August...
an Agency organized on January 1, 2019. The following transactions occurred during the first month of...
an Agency organized on January 1, 2019. The following transactions occurred during the first month of its operation: Jan. 1: Acquired its articles of incorporation from the company and issued 10,000 shares of capital stock in exchange for cash Rs. 10, 00,000 Jan. 5: Purchased office building at Rs. 500,000 in cash. The building is valued Rs.200,000 and the remainder is assigned to the valuation of land. Jan. 7: Signed 2-year promissory note for Rs.500, 000 Jan. 10: Purchased office...
The following are the transactions occurred in the first month of his business E&O Consultancy. January...
The following are the transactions occurred in the first month of his business E&O Consultancy. January 1. Mr.said introduced RO.45,000 as initial investment to start his new business 2. Business purchased 10 computers for RO.2,500 from Alain computers and paid cash RO.800 immediately and balance agreed to pay later 3. Business obtains a loan of RO.15,000 from a bank in Sohar 5. Business provide audit service to a listed company invoice has given for OR.1500, but the client informed that...
The following transactions occurred during December, the first month of operations for Harris Company. Prepare journal...
The following transactions occurred during December, the first month of operations for Harris Company. Prepare journal entries and create a T-account for accounts payable that includes the following five transactions. 1 Purchased $1,100 of inventory on account. 2 Purchased $900 of inventory on account. 3 Paid suppliers $1,200. 4 Purchased $1,000 of inventory on account. 5 Paid suppliers $900.
Jan 1, Abi started a photography business. During January, the following transactions occurred and were recorded...
Jan 1, Abi started a photography business. During January, the following transactions occurred and were recorded in the company's books: Abi invested $13,700 cash in the business in exchange for common stock. Abi contributed $22,000 of photography equipment to the business. The company paid $2,300 cash for an insurance policy covering the next 24 months. The company received $5,900 cash for services provided during January. The company purchased $6,400 of office equipment on credit. The company provided $2,950 of services...
Blackberry Mountain Inc began business on January 1, 2020. The following transactions occurred during the month...
Blackberry Mountain Inc began business on January 1, 2020. The following transactions occurred during the month of January. 1 Company issued common stock for $21,000 2a Supplies are purchased for $3,000. 2b Insurance is paid for 6 months beginning January 1: $5,400 (record as an asset) 2c Rent is paid for 3 months beginning in January: $4,500 (record as an asset) 3 Blackberry Mountain Inc borrows $45,000 from 1st State Bank (due in the year 2025) at 12% annual interest....
During November, the first month of operations, the following transactions occurred: Date Event 1-Nov Paid $7,200...
During November, the first month of operations, the following transactions occurred: Date Event 1-Nov Paid $7,200 for 12 months rent on office space 2-Nov Purchased office furniture for $8,950. 3-Nov Purchased $11,354 of additional office supplies on account. 8-Nov Borrowed 20,000 from the bank for operating cash. The note has a 3% interest rate (simple interest) and is to be paid back in 4 years 15-Nov Received $10,800 from Fortuna Inc. for work to be performed over the next 12...
Following are the transactions and adjustments that occurred during the first year of operations at Kissick...
Following are the transactions and adjustments that occurred during the first year of operations at Kissick Co. Issued 192,000 shares of $4-par-value common stock for $768,000 in cash. Borrowed $530,000 from Oglesby National Bank and signed a 11% note due in three years. Incurred and paid $380,000 in salaries for the year. Purchased $640,000 of merchandise inventory on account during the year. Sold inventory costing $590,000 for a total of $920,000, all on credit. Paid rent of $110,000 on the...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT