Search the Internet for services that provide access to business angels or informal investors. How do these sites work? If you were an entrepreneur looking for funding, how much would it cost to use this service? How many business angels are registered on the typical database? How many entrepreneurs are registered on the typical database? How effective do you believe these services are? (Use data where possible to back up your answer.)
In: Operations Management
Which of these is/are true about stored procedures?
A user defined stored procedure can be created in a user-defined database or a resource database
Repeatable & abstractable logic can be included in user-defined stored procedures
To call output variables in a stored procedure with output parameters, you need to declare a variables outside the procedure while invocation
Temporary stored procedures are nothing but system stored procedures provided by SQL Server
In: Computer Science
Discussion Topics:
Assume that you have a Saudi league player database. In this
database, you have a table containing players’ attributes such as
(Name, age, position, etc.) and you decided to add information
about players’ agents. Would you represent the agent information as
attributes in the player table or would you create an entity set
for players’ agents? Justify your answer.
Note: Provide answers in your own words.
In: Computer Science
Consider the following scenario:
An electronics manufacturer produces a range of consumer and commercial grade electronic devices. These include television sets, sound systems, computer monitors, mobile phones and many other products. Each of these products has a name and a unique ID number associated with them.
Components to make these devices can be purchased from a single vendor or from multiple vendors. Each component has a name, unique ID number and may include a component description (this information is optional).
The manufacturer sells its products to commercial buyers and also directly to consumers. The manufacturer keeps track of the name, address and phone numbers of the commercial buyers. Only the postcode for non-commercial buyers is stored.
a) Your first task is to construct an Entity-Relationship diagram that captures entities and their relationships. You are free to make assumptions about any information that you believe is not supplied as long as you state these assumptions. (Your assumptions should not contradict the description!)
b) Translate the E-R diagram from part (a) into a database schema in SQL. * Your DDL statements should define foreign keys that reflect the relationships outlined in the scenario. * Your foreign key contains should have appropriate referential triggered actions defined. Include an explanation of the referential actions. * Make sure that you select reasonable types for each table's attributes
c) The manufacturer requires that all phone numbers from commercial buyers include the country code (e.g. for Australia this will be +61). How can you use the your database to enforce this rule? Include an appropriate SQL statement(s) in your answer.
In: Computer Science
Q9: Mr. Osama Al Rawabi , a research consultant recently conducted a survey of the people from 05 countries regarding the level of education and he has published his study as per below:
|
Country |
Post Graduation |
Graduation |
Higher Secondary |
Primary |
No Answer |
|
China |
7 |
315 |
671 |
506 |
3 |
|
France |
69 |
388 |
766 |
309 |
7 |
|
India |
161 |
514 |
622 |
227 |
11 |
|
UK |
58 |
207 |
1240 |
32 |
20 |
|
USA |
84 |
486 |
896 |
87 |
4 |
Find out the following probabilities: (5Q*1M=5 Marks)
e) Critically compare mutually exclusive and non exclusive events in probability
In: Statistics and Probability
Digg company is evaluation two projects for next year’s capital budgeting. The after-tax cash flow ($) (including depreciation) are following:
Project A Project B
Year 0 -6000 -17500
Year 1 2000 5600
Year 2 2000 5600
Year 3 2000 5600
Year 4 2000 5600
Year 5 2000 5600
Year 6 4000 9000
If company’s WACC is 13%, find NPV, IRR, Payback and discount payback for each project. If the projects are mutually exclusive what is your recommendation to the company.
Specific help and showing of work for the payback discount please!!
In: Finance
Below are the 2018 and 2019 year-end balance sheets for Tran Enterprises:
| Assets: | 2018 | 2017 |
| Cash | $ 200,000 | $ 170,000 |
| Accounts receivable | 864,000 | 700,000 |
| Inventories | 2,000,000 | 1,400,000 |
| Total current assets | $3,064,000 | $2,270,000 |
| Net fixed assets | 6,000,000 | 5,600,000 |
| Total assets | $9,064,000 | $7,870,000 |
Liabilities and equity:
| Accounts payable | $1,400,000 | $1,090,000 |
| Notes payable to bank | 1,600,000 | 1,800,000 |
| Total current liabilities | $3,000,000 | $2,890,000 |
| Long-term debt | 2,400,000 | 2,400,000 |
| Common stock | 3,000,000 | 2,000,000 |
| Retained earnings | 664,000 | 580,000 |
| Total common equity | $3,664,000 | $2,580,000 |
| Total liabilities and equity | $9,064,000 | $7,870,000 |
The firm has never paid a dividend on its common stock, and it issued $2,400,000 of 10-year, non-callable, long-term debt in 2018. As of the end of 2019, none of the principal on this debt had been repaid. Assume that the company's sales in 2018 and 2019 were the same. Which of the following statements must be CORRECT?
|
|||
|
|||
|
|||
|
|||
|
In: Finance
Noel Chappell has started the car repair business for five years. He is interested to know the performance of his business. The statement of financial position is shown below:
|
|||||
|
2018 |
2019 |
||||
|
Assets |
($) |
($) |
|||
|
Cash |
6,000 |
3,000 |
|||
|
Accounts receivable |
14,000 |
17,000 |
|||
|
Inventory |
13,000 |
19,000 |
|||
|
Non-current assets (net) |
27,000 |
20,000 |
|||
|
Total assets |
60,000 |
59,000 |
|||
|
Liabilities and shareholders' equity |
|||||
|
Accounts payable |
20,000 |
22,000 |
|||
|
Long term borrowings |
16,000 |
13,000 |
|||
|
Capital |
24,000 |
24,000 |
|||
|
Total liabilities and shareholders' equity |
60,000 |
59,000 |
|||
Additional information:
Total assets as at 1 July 2017 were $25,000.
Total revenues/sales in 2019 were $180,000 and in 2018 were $140,000.
Profit after tax for 2019 is $36000 and in 2018 is $28000.
Required
(i) Calculate the following ratios for 2018 and 2019:
1. current ratio
2. quick ratio
3. debt ratio
4. asset turnover ratio
5. profit margin
The industry average of the liquidity ratio for similar businesses is also provided:
|
current ratio |
1.3:1 |
|
quick ratio |
0.8:1 |
|
debt ratio |
50% |
|
asset turnover ratio |
4.0:1 |
(ii) Comment on the liquidity and financial stability performance of the business.
In: Accounting
Noel Chappell has started the car repair business for five years. He is interested to know the performance of his business. The statement of financial position is shown below:
|
Noel Chappell |
||||||
|
Statement of Financial Position |
||||||
|
As at 30 June |
||||||
|
2018 |
2019 |
|||||
|
($) |
($) |
|||||
|
Assets |
||||||
|
Cash |
6,000 |
3,000 |
||||
|
Accounts receivable |
14,000 |
17,000 |
||||
|
Inventory |
13,000 |
19,000 |
||||
|
Non-current assets (net) |
27,000 |
20,000 |
||||
|
Total assets |
60,000 |
59,000 |
||||
|
Liabilities and shareholders' equity |
||||||
|
Accounts payable |
20,000 |
22,000 |
||||
|
Long term borrowings |
16,000 |
13,000 |
||||
|
Capital |
24,000 |
24,000 |
||||
|
Total liabilities and shareholders' equity |
60,000 |
59,000 |
||||
Additional information:
Total assets as at 1 July 2017 were $25,000.
Total revenues/sales in 2019 were $180,000 and in 2018 were $140,000.
Profit after tax for 2019 is $36000 and in 2018 is $28000.
Required
(i) Calculate the following ratios for 2018 and 2019:
1. current ratio
2. quick ratio
3. debt ratio
4. asset turnover ratio
5. profit margin
The industry average of the liquidity ratio for similar businesses is also provided:
|
current ratio |
1.3:1 |
|
quick ratio |
0.8:1 |
|
debt ratio |
50% |
|
asset turnover ratio |
4.0:1 |
(ii) Comment on the liquidity and financial stability performance of the business.
In: Accounting
The following facts are for a non-cancellable lease agreement between Alpha Corporation and Beta Corporation, a lessee:
|
Inception Date |
July 1, 2018 |
|
Annual lease payment due at the beginning of each year, starting July 1, 2018 |
$20,066.26 |
|
Purchase option price at end of lease term reasonably certain to be exercised by Beta |
$4,500.00 |
|
Lease term |
5 years |
|
Economic life of leased equipment |
10 years |
|
Lessor’s cost |
$60,000.00 |
|
Fair value of asset at July 1, 2018 |
$88,000.00 |
|
Lessor’s implicit rate |
9% |
|
Lessee’s incremental borrowing rate |
9% |
The collectability of the lease payments is reasonably predictable, and there are no important uncertainties about costs that have not yet been incurred by the lessor. The lessee assumes responsibility for all executory costs. Both Beta and Alpha use IFRS 16.
question 4 - A lease agreement between Alpha Corporation and Beta Corporation is described in the previous question (question 3)
Provide the following for Alpha Corporation, the lessor.
Required:
1. Calculate the amount of gross investment at the inception of the lease.
2. Calculate the amount of net investment at the inception of the lease.
3. Prepare the journal entries to reflect the signing of the lease and to record the receipts and income related to this lease for the years 2018, 2019, and 2020.
In: Accounting