Reference no: EM132481063
After graduating, you have decided to open your own business as a corporation. The project is a company called ABC, Inc. Since you have taken a financial accounting class as part of your undergraduate degree, you have decided to save the money to create the accounting work. This includes understanding that all transactions are recorded properly in appropriate journals, T-Accounts and trial balances and prepare the the financial statements. To accomplish these goals, you must have a full understanding of the accounting cycle.
Problem 1. Create necessary Excel spreadsheets to complete the work. Handwritten journals, T-accounts, or trial balance will not be accepted nor will any other file format. You will be assigned a unique 4-digit ID number that will be used throughout this project. Several of the transactions will require you to multiply your ID Number by a specific amount. This is how each project will have unique results. When using Excel, formulas must be used when. For instance, the transaction occurring on June 1 is ID X 500. Do not just solve this using your calculator and type in the answer. In Excel, you must have a formula such as "=500 x ID". There should be only formulas on the T-accounts and trial balance.
Problem 2. All dollar figures should be rounded to the nearest dollar with no decimals included. Make sure that your submission is formatted with dollar signs and commas and that no decimals are given.
The following transactions are adjusting entries that need to be booked as of June 30, 20XX:
Point 1. The money borrowed on June 2 is an interest-only loan with a 10 percent interest rate. The interest accrues each month even though it is only paid quarterly with the first payment not due until September 2, 20xx. Compute interest on a monthly basis not by number of days.
Point 2. The building has no salvage value and is depreciated on a straight-line basis over 30 years. The equipment has no salvage value and is depreciated on a straight-line basis over 10 years.
Point 3. One month of insurance coverage has expired. Assume an entire month's worth of insurance has expired not only the number of days between payment and end of June.
Point 4. There is $8,500 of inventory left in storage at the end of the month and there was no inventory used for internal purposes.
Point 5. The last payday was June 28th (employees were paid for working that day). Wages accrue at $200 per day.
Required:
Question 1. make adjusting entries in good form based on the above information. Create separate adjusting journal entries from your part 1 journal entries.
Question 2. Post the adjusting journal entries into T-accounts (make sure you have a total amount for each account and that the T-accounts have Part 1 and Part 2 amounts). Remember t-accounts do not go away. Any T-account from Part 1 whether it was affected or not needs to be included.
Question 3. make an adjusted trial balance.
After-tax cost of debt of shama tours
: If the effective tax rate is 40 percent what is the after-tax cost of debt of Shama's tours?
|
Describe features or tenets of the chosen religion
: Choose from one of the following religions: Ancient Egyptian belief, Hinduism, Greek or Roman Polytheism, Native American Religion, Buddhism, Taoism, Judaism.
|
What is the expected rate of return for stock
: What is the expected rate of return for stock A? What is the stand-alone risk for stock A? What is the benefit of holding a portfolio in lieu of a single stock?
|
Explain the purpose of special education assessment
: It is important to understand the purpose of special education assessment and be able to convey that information to parents or other caregivers.
|
Make adjusting entries in good form
: Make adjusting entries in good form based on the above information. Create separate adjusting journal entries from your part 1 journal entries.
|
Determine what is the amount of each payment
: Determine What is the amount of each payment? And what is the total amount of interest that will be paid during the first year?
|
What is the intrinsic value of alpha corp
: 200 shares of Alpha Corp. common stock, a tech company that trades OTC. It has a beta of 1.6, std dev of 15%, a coefficient of determination of 70%
|
How savings account provides annual rate compounded monthly
: If your savings account provides a 6% annual rate compounded monthly, which alternative should you choose? (Assume no default risk.)
|
What are key management actions that scenario may suggest
: What are a few of the key management actions that this scenario may suggest? What are some positive and concrete things that she can do to implement.
|