Case
Azzahra is a book publisher, publishes and distributes educational and non-educational books and sell them to libraries and bookstores within Saudi Arabia and in the Arabian Gulf Region (AGR).
Azzahra employs a professional editorial team. All printing and binding activities are outsourced. The annual revenue total 250 millions Saudi Riyals which are disbursed as follows:
|
In millions |
Cash |
Credit |
Total |
Total Customers |
|
Within Saudi |
40 | 120 | 160 | 4680 |
|
From other AGR |
10 | 80 | 90 | 2120 |
|
Total |
50 | 200 | 250 | 7800 |
Cash expenditures are 150 million Saudi Riyals. Non-cash expenditures are 50 million Saudi Riyals. While revenues may be paid in different currencies, all processed out in the main center in Riyadh and using Saudi Riyal.
Requirement
Suppose you are a member of the professional editorial team and your task is to audit the revenue and accounts receivable. You probably would like to perform your audit in the following order:
1- Establish audit objectives
2- Determine the scope of the audit
3- Apply the Seven Habits of Highly Effective People (expected outcomes).
4- Understand the auditee (gather relevant information, analytical procedures, control
analysis, process flow, process risks)
5- Identify and assess risks
6- Identify key controls
7- Evaluate controls
8- Create test plan
9- Develop work program
10- Gather evidences
11- Evaluate evidences and reach conclusion
12- Develop observation and formulate recommendation.
In: Accounting
Multiple Product Break-Even and Net Income
Planning
Madison Company manufactures and sells the following three
products:
| Red | Blue | Green | |
|---|---|---|---|
| Unit sales | 20,000 | 30,000 | 50,000 |
| Unit sales price | $30 | $62 | $18 |
| Unit variable cost | $18 | $38 | $14 |
Assume that total fixed cost is $324,800.
a. Compute the net income before income tax based on the sales volumes shown above.
| Red | Blue | Green | |
|---|---|---|---|
| Unit contribution margin | Answer | Answer | Answer |
| Total contribution margin | Answer | Answer | Answer |
Net income before income tax $Answer
b. Compute the break-even point in total dollars of revenue and
in specific unit sales volume for each product.
Enter product mix answers in decimal form.
| Product | Product Mix | Contribution Margin per unit | Weighted average unit contribution margin |
|---|---|---|---|
| Red | Answer | Answer | Answer |
| Blue | Answer | Answer | Answer |
| Green | Answer | Answer | Answer |
| Answer |
Break-even Answer units
| Product | Break -even Units | Unit Sales Price | Break-even Sales Revenue |
|---|---|---|---|
| Red | Answer | Answer | Answer |
| Blue | Answer | Answer | Answer |
| Green | Answer | Answer | Answer |
| Answer |
c. Prove your break-even calculations by computing the total contribution margin related to your answer in requirement (b).
| Product | Break -even Units | Unit Contribution Margin | Total Contribution Margin |
|---|---|---|---|
| Red | Answer | Answer | Answer |
| Blue | Answer | Answer | Answer |
| Green | Answer | Answer | Answer |
| Answer |
In: Accounting
Question 1. Starbucks has many fixed assets in its stores. For example, they have various machines to make drinks or cook food. Identify one of those pieces of equipment, conduct internet research to estimate a replacement cost if it were destroyed today, assuming it is January 1st (cost). How many years do you estimate it will be functional and useful to help Starbucks produce revenue (estimated usefule life)? In that time period in the future, how much do you think Starbucks can sell it for (salvage value)? ( If the machine price is 24,550.35)
Once you have the cost of a machine, an estimated useful life and a salvage value, calculate the item’s depreciation expense for its first year. Extrapolate your results over all Starbucks stores and determine the affect on the balance sheet and income statements by comparing if the item were to be depreciated using the straightline verse double-declining balance methods, over the estimated cost, estimated useful life and estimated salvage values you choose. You must show calculations. To answer this question, you may have to conduct research to determine the make/model machines they use. If you can’t figure it out, use a close substitute.
Question 2. From everything you read, analyzed and understand to date about Starbucks, what would you change that would help it increase revenue, control its expenses, or make its assets more efficient? Show how that beneficial change would affect at least one ratio.
In: Accounting
You are one of the three partners in RSM, an auditing firm. This year, RSM was engaged to audit year-end accounts and tax returns of a new and fast-growing engineering consulting company, CPEC. The business had started operations with only a few staff but now it has employees of over 100, still remaining below the size of a company which will require a compulsory audit by the government. During the course of the audit, you have discovered a significant increase in revenue this year compared to last year. Accordingly, your team investigated the increase and discovered a practice which your team believes is not in accordance with the financial reporting framework. Your team found out that one of the owners, who is also the managing director of CPEC, was doing consultancy services to some of his close friends. In effect, consultancy fees for these close friends were recorded as income of the company but not collected. They remain as collectibles of the company in the last five years and the company seem not to have any intention of collecting them. The accountant also have not written them off from the list of bad debts. This practice is also known to the other directors of the company. You have suspicions that this is done to increase the amount of revenue reported in the financial statements. Required: Explain your answer to the following questions: 1. Which fundamental ethical principles in ISA 200 will be affected in this scenario? You can explain more than one ethical principle, if applicable. 2. Is the practice dishonest? Explain your opinion. 3. Explain the impact of this scenario to your firm. 4. What could be the possible course of action?
In: Accounting
Company 1
| Industry Median | 2020 | 2019 | 2018 | 2017 | |
| A/R Turnover | 119.6 | 75.8 | 74.3 | 86.7 | 92.0 |
| Avg. A/R Days | 3.1 | 4.8 | 4.9 | 4.3 | 4.0 |
| Inv Turnover | 3.5 | 5.9 | 5.9 | 6.0 | 5.8 |
| Avg. Inventory Days | 103.0 | 61.3 | 61.8 | 61.3 | 62.6 |
| Avg. A/P Days | 51.0 | 65.3 | 63.0 | 57.8 | 54.3 |
| Fixed Asset Turnover | 2.59 | 2.79 | 2.80 | 2.85 | 2.82 |
| WC / Sales Growth | (1.6%) | (0.6%) | (1.1%) | (1.4%) | (1.7%) |
| Bad Debt Allowance (% of A/R) | - | - | - | - | - |
| ROIC | - | 12.0% | 10.8% | 9.9% | 10.2% |
| Revenue per Employee ($) | - | $214,593.40 | $213,775.90 | $217,706.60 | $211,659.60 |
Company 2
| Industry Median | 2020 | 2019 | 2018 | 2017 | |
| A/R Turnover | 26.8 | 74.2 | 75.1 | 74.7 | 68.2 |
| Avg. A/R Days | 13.6 | 4.9 | 4.8 | 5.0 | 5.4 |
| Inv Turnover | 10.2 | 13.7 | 14.2 | 14.6 | 14.1 |
| Avg. Inventory Days | 35.6 | 26.6 | 25.7 | 25.4 | 26.4 |
| Avg. A/P Days | 31.8 | 23.7 | 22.9 | 22.6 | 23.9 |
| Fixed Asset Turnover | 5.21 | 4.86 | 5.67 | 5.83 | 5.68 |
| WC / Sales Growth | (0.4%) | (0.1%) | (0.4%) | 0.1% | 0.1% |
| Bad Debt Allowance (% of A/R) | 1.7% | - | - | - | - |
| ROIC | - | 5.5% | 13.1% | 4.1% | 8.8% |
| Revenue per Employee ($) | - | $275,418.90 | $268,651.90 | $275,026.90 | $263,929.10 |
Please discuss which company operates more efficiently. The
discussion may include, but not exhaustive to the inventory
management system, capacity utilization, supply chain etc
In: Finance
Question 1
A company is building an amusement park and has the following projected cashflows. Costs consist of building costs and staff salaries:
|
Year |
Building costs (assume as being paid at start of each respective year) |
|
1 |
$100,000 |
|
2 |
$50,000 |
|
3 |
$30,000 |
|
4 |
$45,000 |
5 $0 for year 5 and all future years for building costs
Staff salaries
$4,000 for year 1, increasing by a discrete step of $100 at the start of each future year, but paid continuously throughout each year, every year into the future
Revenue consists of ticket sales, merchandise sales, and food and beverage sales: Food and beverages
For all 30 years,
Tickets: $2000 per month for all years. Assume as paid at end of each month.
Merchandise: Equal to 1/3 of ticket sales
Food and beverages: $4250 per year, increasing by $50 per year in each future year. Assume the amount in each year is earned (paid) in the middle of each year.
Investors in the amusement park want to know what the Net Present Value (NPV) of this project is, assuming:
a risk discount rate (effective yield) of 14% per annum; and
a 30-year time horizon (i.e. all costs and revenues cease after 30 years).
(a) Calculate the present value of costs. Show all workings. [4 marks]
(a) Calculate the present value of revenue. Show all workings. [4 marks]
(b) Hence, calculate the NPV of the overall project. [1 mark]
In: Finance
Brady Construction Company contracted to build an apartment
complex for a price of $5,200,000. Construction began in 2021 and
was completed in 2023. The following is a series of independent
situations, numbered 1 through 6, involving differing costs for the
project. All costs are stated in thousands of dollars.
| Estimated Costs to Complete | ||||||||||||
| Costs Incurred During Year | (As of the End of the Year) | |||||||||||
| Situation | 2021 | 2022 | 2023 | 2021 | 2022 | 2023 | ||||||
| 1 | 1,520 | 2,190 | 960 | 3,150 | 960 | — | ||||||
| 2 | 1,520 | 960 | 2,480 | 3,150 | 2,480 | — | ||||||
| 3 | 1,520 | 2,190 | 1,760 | 3,150 | 1,660 | — | ||||||
| 4 | 520 | 3,020 | 1,040 | 3,640 | 885 | — | ||||||
| 5 | 520 | 3,020 | 1,440 | 3,640 | 1,660 | — | ||||||
| 6 | 520 | 3,020 | 2,000 | 4,800 | 1,880 | — | ||||||
Required:
Complete the following table (Do not round intermediate
calculations. Enter answers in dollars. Round your final answers to
the nearest whole dollar. Negative amounts should be indicated by a
minus sign.)
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
In: Accounting
Rock Solid Bank and
Trust (RSB&T) offers only checking accounts. Customers can
write checks and use a network of automated teller machines.
RSB&T earns revenue by investing the money deposited;
currently, it averages 6.90 percent annually on its investments of
those deposits. To compete with larger banks, RSB&T pays
depositors 0.50 percent on all deposits. A recent study classified
the bank’s annual operating costs into four activities.
| Activity | Cost Driver | Cost | Driver Volume | |||
| Using ATM | Number of uses | $ | 4,050,000 | 5,400,000 | uses | |
| Visiting branch | Number of visits | 2,430,000 | 405,000 | visits | ||
| Processing transaction | Number of transactions | 17,820,000 | 216,000,000 | transactions | ||
| Managing functions | Total deposits | 16,200,000 | $ | 1,012,500,000 | in deposits | |
| Total overhead | $ | 40,500,000 | ||||
Data on two
representative customers follow.
| Customer A | Customer B | |||||
| ATM uses | 100 | 200 | ||||
| Branch visits | 5 | 20 | ||||
| Number of transactions | 40 | 1,500 | ||||
| Average deposit | $ | 6,000 | $ | 6,000 | ||
Required:
a. Compute RSB&T's operating profits. Operating Profit?
b. Compute the profit from Customer A and Customer B, assuming that customer costs are based only on deposits. Interest costs = 0.50 percent of deposits; operating costs are 4 percent (= $40,500,000/$1,012,500,000) of deposits.
c. Compute the profit from Customer A and Customer B, assuming that customer costs are computed using the information in the activity-based costing analysis.
Customer A Customer B
Sales Revenue
Interest on Deposit
Total Operating Cost
Customer Profit/Loss
In: Accounting
Magi Chen is the managing director of Sun Construction Pty Ltd, a family owned business that provides construction services. As Magi is interested in purchasing some new construction equipment’s for her business, she has approached her local bank for finance. The bank has asked that Magi provide an audited financial statement to assist them in considering her loan application. Magi has approached your audit firm for this service and you have been allocated the task of auditing Sun Construction for the year ended 30 June 2019. You have undertaken a preliminary review of the business and determined that a substantive testing approach would be suitable and appropriate. You are currently preparing an audit program for the revenue cycle. The following information has been obtained from your review: • Magi usually works 120 hours a fortnight. Part of this time is spent travelling between different clients and is not charged to the clients. The remaining time is charged at $60 per hour, regardless of the task undertaken. • Customers typically pay Magi in cash for the work undertaken, except for a small number of regular small-business customers. Magi allows these customers to pay on account by bank transfer on a monthly basis. • Magi supplies each cash customer with a written receipt, prepared manually from a receipt book purchased at the local news-agency. The book contains pre-numbered blank receipts, which are completed in duplicate. Required: For each of the assertions of occurrence, completeness and accuracy, identify a procedure(s) you could use to audit Sun Construction's revenue.
In: Accounting
Information concerning Marigold Corporation’s intangible assets is as follows.
| 1. | On January 1, 2017, Marigold signed an agreement to operate as a franchisee of Hsian Copy Service, Inc. for an initial franchise fee of $80,000. Of this amount, $16,000 was paid when the agreement was signed, and the balance is payable in 4 annual payments of $16,000 each, beginning January 1, 2018. The agreement provides that the down payment is not refundable and no future services are required of the franchisor. The present value at January 1, 2017, of the 4 annual payments discounted at 10% (the implicit rate for a loan of this type) is $50,720. The agreement also provides that 8% of the revenue from the franchise must be paid to the franchisor annually. Marigold’s revenue from the franchise for 2017 was $800,000. Marigold estimates the useful life of the franchise to be 10 years. (Hint: You may want to refer to Chapter 18 to determine the proper accounting treatment for the franchise fee and payments.) | |
| 2. | Marigold incurred $80,000 of experimental and development costs in its laboratory to develop a patent that was granted on January 2, 2017. Legal fees and other costs associated with registration of the patent totaled $23,200. Marigold estimates that the useful life of the patent will be 8 years. | |
| 3. | A trademark was purchased from Shanghai Company for $46,000 on July 1, 2014. Expenditures for successful litigation in defense of the trademark totaling $-1,700 were paid on July 1, 2017. Marigold estimates that the useful life of the trademark will be 20 years from the date of acquisition. |
Prepare a schedule showing the intangible assets section of Marigold’s balance sheet at December 31, 2017.
In: Accounting