Please complete the spreadsheet template:
Trans no. Transaction
1. Pamela Wong, the owner, opened a checking account for the business by depositing $48,000 of her personal funds.
2. Paid the monthly rent of $1,500.
3. Bought office furniture on account for $1,000.
4. Pamela Wong invested $3,000 of office equipment in the business.
5. Paid cash for a new computer for the business, $5,000.
6. Paid for an advertisement in the local newspaper, $200.
7. Completed graphic desktop publishing services for a client and sent a bill for $800.
8. Paid $700 on account for the office furniture bought earlier.
9. Received $500 on account from a client.
10. Pamela Wong withdrew $1,000 for personal use.
11. Received $400 cash for desktop publishing services completed for a client.

Answer:

I used an excel spreadsheet sine there is not enough room here.        

Explanation:

Excel templates make it simpler to create a spreadsheet with a polished appearance by including all of the following, with the exception of Data.

To eliminate the necessity for the user to generate those designs from scratch, templates are made to specify the fundamental structure of each document that is repeated.

A template typically includes formatting and pre-defined formulas. However, it won't include any data as the template's goal is to have a consistent structure but allow for variable values so that it can respond appropriately to the data.

Formatting and pre-made formulas are frequently included in templates. Although the template aims to have a consistent structure and allow for variable values so that it can react appropriately to the data, it won't contain any data.

Any template will therefore include design but not data. We are able to make a new one, modify an existing template, or utilize the default template.

Learn more about Templates here

https://brainly.com/question/13270285

# SPJ 5

Learning design software, applying to college and creating a website to showcase work are examples of ______ that lead to a career as a graphic artist?

Brett, the manager at Warson’s Diner, plans to promote Keisha, one of the waitresses, to the position of an assistant manager. However, the owner, being racially biased, prevents him from doing so. Later, when Brett wants to promote one of the delivery boys to waiter, the owner again vetoes his recommendation on the grounds that his customers would feel uncomfortable having a black man deliver their food. Brett, extremely frustrated, offers Keisha and the delivery boy their promotions as he finds them deserving. Subsequently, Brett gets fired. Which of the following holds true in this scenario?

a. Brett has a cause of action against Warson’s Diner for retaliatory discharge under Title VII of the Civil Rights Act of 1964.
b. Brett has a cause of action against Warson’s Diner based on the bona fide occupational qualification defense.
c. Brett is liable for racial discrimination because as a manager he failed to change the company’s policy regarding promotion of African-Americans.
d. Brett is liable because he failed to follow the instructions provided by his employer.

g you are eligible for a 30 year fixed rate home mortgage with 3.6% interest rate what is the maximum loan you can get

​If the price level increases by 2 percent each year, the inflation rate is increasing. a. True b. False

Statz Company had sales of $1,900,000 and related cost of goods sold of $1,100,000 for its first year of operations ending December 31, 20Y1. Statz provides customers a refund for any returned or damaged merchandise. At the end of 20Y1, Statz Company estimates that customers will request refunds for 1.7% of sales and estimates that merchandise costing $12,000 will be returned. Assume that on February 3, 20Y2, Buck Co. returned merchandise with an invoice amount of $5,300 for a cash refund. The returned merchandise originally cost Statz Company $3,200.

Required:
a. Journalize the adjusting entries on December 31 to record the expected customer returns.
b. Journalize the entries to record the returned merchandise and cash refund to Buck Co. on February 3.

Major improvements in computer information technology in the 1990s fueled an increase in investment demand in the United States (a large open economy). Graphically illustrate the effect of an increase of U.S. investment using the Large Open Economy Model. Clearly label the axes and curves in each of your graphs in the model. Clearly indicate the direction of any shifts in the curves.

Mirr, Inc. was incorporated on January 1, year 1, with proceeds from the issuance of $750,000 in stock and borrowed funds of $110,000. During the first year of operations, revenues from sales and consulting amounted to $82,000, and operating costs and expenses totaled $64,000. On December 15, Mirr declared a $3,000 cash dividend, payable to stockholders on January 15, year 2. No additional activities affected owners' equity in year 1. Mirr's liabilities increased to $120,000 by December 31, year 1. On Mirr's December 31, year 1 balance sheet, total assets should be reported at:_______

The manager of ABC, Inc decides to order the same number of widgets this year as last year. The manager has made a(n) ________ decision.

Consider each of the transactions below. All of the expenditures were made in cash.

a. The Edison Company spent $16,000 during the year for experimental purposes in connection with the development of a new product.
b. In April, the Marshall Company lost a patent infringement suit and paid the plaintiff $9,500.
c. In March, the Cleanway Laundromat bought equipment. Cleanway paid $10,000 down and signed a noninterest-bearing note requiring the payment of $20,000 in nine months. The cash price for this equipment was $27,000.
d. On June 1, the Jamsen Corporation installed a sprinkler system throughout the building at a cost of $32,000.
e. The Mayer Company, plaintiff, paid $16,000 in legal fees in November, in connection with a successful infringement suit on its patent.
f. The Johnson Company traded its old equipment for new equipment. The new equipment has a fair value of $11,200. The old equipment had an original cost of $9,400 and a book value of $4,200 at the time of the trade. Johnson also paid cash of $8,800 as part of the trade. The exchange has commercial substance.

Required:
Prepare journal entries to record each of the above transactions.

Del Gato Clinic's cash account shows a $11,589 debit balance and its bank statement shows $10,555 on deposit at the close of business on June 30. Outstanding checks as of June 30 total $1,829. The June 30 bank statement lists a $16 bank service charge. Check No. 919, listed with the canceled checks, was correctly drawn for $467 in payment of a utility bill on June 15. Del Gato Clinic mistakenly recorded it with a debit to Utilities Expense and a credit to Cash in the amount of $476. The June 30 cash receipts of $2,856 were placed in the bank's night depository after banking hours and were not recorded on the June 30 bank statement.
Prepare its bank reconciliation using the above information.
DEL GATO CLINIC
Bank Reconciliation
June 30
Book balance
Add: Bank statement balance
Add:
Deduct: Deduct:
Adjusted bank balance Adjusted book balance

Casino Inc. expects to pay a dividend of $6 per share at the end of year 1 (Div1) and these dividends are expected to grow at a constant rate of 6 percent per year forever. If the required rate of return on the stock is 20 percent, what is the current value of the stock today?

Type the correct answer in the box. Spell all words correcty.
George has to present the goals of information management to his team member. What is a goal of Information management?
The goal of Information management is to identify information requirements for various what levels

Presented below are condensed financial statements adapted from those of two actual companies competing as the primary players in a specialty area of the food manufacturing and distribution industry. ($ in millions, except per share amounts.)
Balance Sheets
Metropolitan Republic
Assets $ 179.3 $ 37.1
Cash
Accounts receivable (net) 422.7 325.0
Short-term investments — 4.7
Inventories 466.4 635.2
Prepaid expenses and other current assets134.6 476.7
Current assets $ 1,203.0 1,478.7
Property, plant, and equipment (net) 2,608.2 2,064.6
Intangibles and other assets 210.3 464.7
Total assets $ 4,021.5 $4,008.0
Liabilities and Shareholders’ Equity
Accounts payable $ 467.9 691.2
Short-term notes 227.1 557.4
Accruals and other current liabilities 585.2 538.5
Current liabilities $ 1,280.2 1,787.1
Long-term debt 535.6 542.3
Deferred tax liability 384.6 610.7
Other long-term liabilities 104.0 95.1
Total liabilities $ 2,304.4 3,035.2
Common stock (par and additional paid-in capital)
144.9 335.0
Retained earnings 2,476.9 1,601.9
Less: treasury stock (904.7) (964.1)
Total liabilities and shareholders’ equity $
4,021.5 4,008.0
Income Statements
Net sales 5,698.0 7,768.2
Cost of goods sold (2,909.0) (4,481.7)
Gross profit $ 2,789.0 3,286.5
Operating expenses (1,743.7 ) (2,539.2)
Interest expense (56.8) (46.6)
Income before taxes $ 988.5 700.7
Tax expense (394.7) (276.1)
Net income 593.8 424.6
Net income per share $ 2.40 6.50
Note: Because comparative statements are not provided you should use year-end balances in place of average balances as appropriate.
Required:
Calculate the rate of return on assets for the following companies
Calculate the return on assets for both companies.
Calculate the Rate of return on shareholders’ equity for the following companies
Calculate the equity multiplier for the following companies.
Calculate the acid-test ratio and current ratio for the following companies.
Calculate the receivables and inventory turnover ratios the following companies.
Calculate the times interest earned ratio for the following companies.

If bad debt expense for the year was $40,000, what was the amount of bad debts written off during the year?

You are considering four hotels that differ from each other with respect to their price and customer reviews:

If the college strictly enforces the rent ceiling of ​$250 a​ month, the​ on-campus housing market is​

Question 6 of 10
Which economic tool would most likely be used as part of a contractionary
monetary policy?
A. Lowering interest on reserves
B. Reducing the discount rate
C. Raising the reserve requirement
D. Buying treasury securities

All of the following are threats to a sustainable, long-term competitive advantage EXCEPT ________. Group of answer choices

Eye Deal Optometry leased vision-testing equipment from Insight Machines on January 1, 2021. Insight Machines manufactured the equipment at a cost of $350,000 and lists a cash selling price of $437,810. Appropriate adjusting entries are made quarterly.

Related Information:

Lease term 5 years (20 quarterly periods)
Quarterly lease payments $26,250 at Jan. 1, 2021, and at Mar. 31, June 30, Sept. 30, and Dec. 31 thereafter
Economic life of asset 5 years
Interest rate charged by the lessor 8%

Required:
a. Prepare appropriate entries for Eye Deal to record the arrangement at its beginning, January 1, 2021, and on March 31, 2021.
b. Prepare appropriate entries for Insight Machines to record the arrangement at its beginning, January 1, 2021, and on March 31, 2021.

Regency Inn leased a rental office in the lobby of its hotel to Americar, a car rental agency. Wagner rented a car from Americar, and while walking through the hotel parking lot to reach her rental car, she was robbed and raped. Wagner sued Regency Inn for damages, alleging that they maintained a public nuisance. A clause in the lease held that Americar was responsible to indemnify Regency Inn for any damages suffered due to the operation of the car rental agency. At the time of the assault on Wagner, Americar was a holdover tenant.
Can Regency Inn claim indemnification under these conditions? Wagner v. Regency Inn Corp., 463 N.W.2d 450 (1990).

Re-Tire produces bagged mulch made from recycled tires. Production involves shredding tires and packaging the pieces for sale in the bagging department. All direct materials enter in the first process. The following describes production operations for October.

Direct materials used $226,000
Direct labor used 30% in Shredding; 70% in Bagging. $112,000
Predetermined overhead rate (based on direct labor) 165 %
Transferred to Bagging $206,500
Transferred to finished goods $583,000

The company's revenue for the month totaled $470,000 from credit sales, and its cost of goods sold for the month is $240,000.

Required:
Prepare summary journal entries dated October 31 to record its October production activities for:

a. Direct materials usage
b. Direct labor incurred
c. Overhead applied
d. Goods transfer from Shredding to Bagging.
e. Goods transfer from Bagging to finished goods.
f. Credit sales
g. Cost of goods sold.

Farley Inc. has perpetual preferred stock outstanding that sells for $50 a share and pays a dividend of $5.00 at the end of each year. What is the required rate of return? Round your answer to two decimal places.

Presented below are four statements which you are to identify as true or false.
1. GAAP is the term used to indicate the whole body of FASB authoritative literature.
2. Any company claiming compliance with GAAP must comply with most standards and interpretations but does not have to follow the disclosure requirements.
3. The primary governmental body that has influence over the FASB is the SEC.
4. The FASB has a government mandate and therefore does not have to follow due process in issuing a standard.

leased the asset on a 2-year lease, the payment would be $110 at the begin- ning of each year. If RC borrowed and bought, the bank would charge 10% interest on the loan. In either case, the equipment is worth nothing after 2 years and will be discarded. Should RC lease or buy the equipment?

Demarco and Janine Jackson have been married for 20 years and have four children who qualify as their dependents (Damarcus, Janine, Michael, and Candice). The couple received salary income of $100,000 and qualified business income of $10,000 from an investment in a partnership, and they sold their home this year. They initially purchased the home three years ago for $200,000 and they sold it for $250,000. The gain on the sale qualified for the exclusion from the sale of a principal residence. The Jacksons incurred $16,500 of itemized deductions, and they had $3,550 withheld from their paychecks for federal taxes. They are also allowed to claim a child tax credit for each of their children. However, because Candice is 18 years of age, the Jacksons may only claim the child tax credit for other qualifying dependents for Candice. (Use the tax rate schedules.)
Comprehensive Problem 4-55 Parts-c through f
a. What would their taxable income be if their itemized deductions totaled $28,000 instead of $16,500?
b. What would their taxable income be if they had $0 itemized deductions and $6,000 of for AGI deductions?
c. Assume the original facts but now suppose the Jacksons also incurred a loss of $5,000 on the sale of some of their investment assets. What effect does the $5,000 loss have on their taxable income?

Question 3
20 pts
Solve the problem
A normal distribution has a limited range and can be skewed in either direction.
True
0 False
Next >

What type of competition stems from new products, new processes, new markets, and new forms of business organization

Dom has $90,000 that he wishes to invest now in order to use the accumulation for purchasing a retirement annuity in five years. After consulting with his financial advisor, he has been offered four types of fixed-income investments, labeled as investments A, B, C, and D.
Investments A and B are available at the beginning of each of the next five years (call them years 1–5). Each dollar invested in A at the beginning of a year returns $1.20 (a profit of $0.20) two years later, in time for immediate reinvestment. Each dollar invested in B at the beginning of a year returns $1.36 three years later.
Investments C and D will each be available just once in the future. Each dollar invested in C at the beginning of year 2 returns $1.66 at the end of year 5. Each dollar invested in D at the beginning of year 5 returns $1.12 at the end of year 5.
Your uncle is obligated to make a balloon payment on an existing loan in the amount of $24,000 at the end of year 3. He wants to make that payment out of the investment account.
1) Devise an investment plan for your uncle that maximizes the value of the investment account at the end of five years. How much money will be available for the annuity in five years?
2) Show the network diagram corresponding to the solution in (1). That is, label each of the arcs in the solution and verify that the flows are consistent with the given information.

If a specific economy has extra capital resources available,
be able to produce top-quality goods and services.
continually look to expand and invest.
be able to produce more goods and services needed and wanted by society.
have additional labor available to focus on production.
this

Van Frank Telecommunications has a patent on a cellular transmission process.
1. The company has amortized the $19.80 million cost of the patent on a straight-line basis, since it was acquired at the beginning of 2012.
2. Due to rapid technological advances in the industry, management decided that the patent would benefit the company over a total of six years rather than the nine-year life being used to amortize its cost.
3. The decision was made at the end of 2016 (before adjusting and closing entries).
What is the appropriate adjusting entry for patent amortization in 2016 to reflect the revised estimate.
(If no entry is required for a transaction/event, select "No journal entry required" in the first account field. Enter your answers in millions rounded to 2 decimal places (i.e., 5,500,000 should be entered as 5.50).) Record the adjusting entry for patent amortization in 2016.