What are the answers to Required 1 (filling in the spreadsheet) and Required 2 (filling in the spreadsheet)?
Q: (Click on the following icon in order to copy its contents into a spreadsheet.) Project Year 0 Year…
A: NPV is the difference between present value of all cash inflows and initial investment. IRR is the…
Q: Which "view" gives you the ability to drop and drag fields to create relationships between tables?…
A: In a Relationship View, we can create relationships between tables.
Q: ve it on excel.
A: The given problem can be solved using RATE function in excel. RATE function computes cost of capital…
Q: Provide the complete worksheet
A: Worksheet is a 10 column statement that is being prepared in business to show unadjusted general…
Q: Please compute for the letter E to L requirements.
A: Hi Student, since there are multiple subparts, we will answer only three subparts. If you want…
Q: Give 3 benefits/Importance of using spreadsheet in accounting
A: According to dictionary, spreadsheet is an electronic document in which data is arranged in rows and…
Q: ubmit a picture that is related to Accountancy. Give three mathematical terms describing the…
A: Basic Accounting, needs to explain accounting concept with the help of picture
Q: 1. The purpose of the form 2. Identify four line items and explain why they are listed 3. Fill out…
A: Tax is a charge which is charged on the taxable income. This tax amount is to be paid to the…
Q: Q6: Systems flow charts explain and give two examples
A: “Since you have asked multiple questions, we will solve the first question for you. If you want any…
Q: 1. Post the above transactions to T-accounts.
A: Required to fill the journal entries in various accounts
Q: adm.
A: The above problem is related to cost volume profit ananlysis.…
Q: State the purpose for each of the following six built-in spreadsheet functions. (a) PV(i%, n, A, F)…
A: a) In spreadsheet PV(i%,n, A, F) is used to determine the present value (PV) of an amount (F) or…
Q: Give a example of accruals and write a numeric example for it with Accountıng entries
A: Meaning of Accrual: Accrual meaning in accounting term means, recognition of revenues and costs as…
Q: Using the spreadsheet answer question (c) please
A: Given, Volatility of the market = 10% Expected Return = 8% Risk-free rate = 3%
Q: Can I get a breakdown on how this is done all I'm seeing is a bunch of numbers
A: In the solution provided present value of all the coupon payments and future value is done to…
Q: Question 17: Why sort table data? Answer: A. B. C. D. O You want to display only the table rows that…
A: Sorting means to arrange data in ascending or descending order. It can also be used to arrange data…
Q: The Financial position graph is suitable for Select one: O a. Data Input O b. Data Process O c.…
A: Financial Position depicts the position and status of recorded assets, liabilities, and equity of…
Q: Create worksheet on A. albelto Account
A: Accounting work sheet: It is spreadsheet where all the accounting records are kept. In book-keeping…
Q: What is the full equation or data points used for the IRR? The last part is cut off. I have attached…
A: Internal rate of return (IRR) is the discount rate at which NPV of the project is zero. NPV=Initial…
Q: 1. The --------------data model was developed specifically for use in designing accounting…
A: We’ll answer the first question since the exact one wasn’t specified. Please submit a new question…
Q: information prepar nt for Steven and C
A: A sale and lease back agreement is a contract between two parties where one party sells an asset to…
Q: (Click on the following icon g in order to copy its contents into a spreadsheet.) Year 1 4 Return -…
A: A statistical measure that represents the spread among the return of the investment is term as the…
Q: jorunalize the transactions
A: Journal entries recording is the first step in accounting cycle process, in which atleast one…
Q: Fill out the missing column
A: Net revenue = Gross profit + Cost of goods sold = 511000+673400 = $1184400 Operating expense = Net…
Q: The following are the cells that were missing in the spreadsheet: - Total - Grand Total - Change…
A: The given problem can be solved using simple multiplication, addition and subtraction formulas in…
Q: Which of the following associations requires a separate table in the database? a. 1:1 b. 1:M c. M:M…
A: Association: The type of relationship which one entity shares with other entity is called…
Q: dger turo
A: Explanation of Concept Ledger Posting : is the step in the process of preparing the books accounts…
Q: Please make all three questions and answers able to be copied over to word to be able to edit the…
A: Accounting equation means where entity assets is equal to its liability and capital.
Q: Answer the below question: B- the CC for machine B=
A: Time value of money (TVM) is used to measure the value of money at different point of time in the…
Q: explain Program flowcharts and give two examples
A: Flowcharts represents the diagrammatic form of the algorithm as well as state the approach of step…
Q: (Click on the following icon in order to copy its contents into a spreadsheet.) Nuch Prosont Valuo…
A: using the present value function in excel
Q: Each relational database table contains records (listed in ) and attributes (listed in columns; rows…
A: Relational database is a database which provides data access to database that are connected to one…
Q: Prepare the Worksheet
A: Worksheet is a summary of general ledger account balances in the form of unadjusted trial balance,…
Q: Prepare a worksheet.
A: Trial balance is the summary of all general ledger account balances in the business. Total of debits…
Q: 000 1000 1500 3000 $2.000
A: Future value is amount of deposit made and also interest accumulated over the period of time of…
Q: A T-account is * a way of depicting the basic form of an account. what the computer uses to organize…
A: T account is representation of induvial accounts having credit or debit transactions. It depicts the…
Q: Match each example with a component of a computerized accounting information system. Components may…
A: component of a computerized accounting information system. Components may be used more than once.:…
Q: Why are working papers important? Give atleast 5 reasons.
A: Working papers are those papers prepared as well as organised by the auditors in the manner which…
What are the answers to Required 1 (filling in the spreadsheet) and Required 2 (filling in the spreadsheet)?
Trending now
This is a popular solution!
Step by step
Solved in 3 steps
- On July 1, 2018, Mundo Corporation purchased factory equipment for 50,000. Residual value was estimated at 2,000. The equipment will be depreciated over 10 years using the double-declining balance method. Counting the year of acquisition as one-half year, Mundo should record 2019 depredation expense of: a. 7,680 b. 9,000 c. 9,600 d. 10,000Gray Companys financial statements showed income before income taxes of 4,030,000 for the year ended December 31, 2020, and 3,330,000 for the year ended December 31, 2019. Additional information is as follows: Capital expenditures were 2,800,000 in 2020 and 4,000,000 in 2019. Included in the 2020 capital expenditures is equipment purchased for 1,000,000 on January 1, 2020, with no salvage value. Gray used straight-line depreciation based on a 10-year estimated life in its financial statements. As a result of additional information now available, it is estimated that this equipment should have only an 8-year life. Gray made an error in its financial statements that should be regarded as material. A payment of 180,000 was made in January 2020 and charged to expense in 2020 for insurance premiums applicable to policies commencing and expiring in 2019. No liability had been recorded for this item at December 31, 2019. The allowance for doubtful accounts reflected in Grays financial statements was 7,000 at December 31, 2020, and 97,000 at December 31, 2019. During 2020, 90,000 of uncollectible receivables were written off against the allowance for doubtful accounts. In 2019, the provision for doubtful accounts was based on a percentage of net sales. The 2020 provision has not yet been recorded. Net sales were 58,500,000 for the year ended December 31, 2020, and 49,230,000 for the year ended December 31, 2019. Based on the latest available facts, the 2020 provision for doubtful accounts is estimated to be 0.2% of net sales. A review of the estimated warranty liability at December 31, 2020, which is included in other liabilities in Grays financial statements, has disclosed that this estimated liability should be increased 170,000. Gray has two large blast furnaces that it uses in its manufacturing process. These furnaces must be periodically relined. Furnace A was relined in January 2014 at a cost of 230,000 and in January 2019 at a cost of 280,000. Furnace B was relined for the first time in January 2020 at a cost of 300,000. In Grays financial statements, these costs were expensed as incurred. Since a relining will last for 5 years, Grays management feels it would be preferable to capitalize and depreciate the cost of the relining over the productive life of the relining. Gray has decided to nuke a change in accounting principle from expensing relining costs as incurred to capitalizing them and depreciating them over their productive life on a straight-line basis with a full years depreciation in the year of relining. This change meets the requirements for a change in accounting principle under GAAP. Required: 1. For the years ended December 31, 2020 and 2019, prepare a worksheet reconciling income before income taxes as given previously with income before income taxes as adjusted for the preceding additional information. Show supporting computations in good form. Ignore income taxes and deferred tax considerations in your answer. The worksheet should have the following format: 2. As of January 1, 2020, compute the retrospective adjustment of retained earnings for the change in accounting principle from expensing to capitalizing relining costs. Ignore income taxes and deferred tax considerations in your answer.Refer to the information for Cox Inc. above. What amount would Cox record as depreciation expense for 2019 if the units-of-production method were used ( Note: Round your answer to the nearest dollar)? a. $179,400 b. $184,000 c. $218,400 d. $224,000
- On May 10, 2019, Horan Company purchased equipment for 25,000. The equipment has an estimated service life of 5 years and zero residual value. Assume that the straight-line depreciation method is used. Required: Compute the depreciation expense for 2019 for each of the following four alternatives: 1. Horan computes depreciation expense to the nearest day. (Use 12 months of 30 days each and round the daily depreciation rate to 2 decimal places.) 2. Horan computes depreciation expense to the nearest month. Assets purchased in the first half of the month are considered owned for the whole month. 3. Horan computes depreciation expense to the nearest whole year. Assets purchased in the first half of the year are considered owned for the whole year. 4. Horan records one-half years depreciation expense on all assets purchased during the year.Chapman Inc. purchased a piece of equipment in 2018. Chapman depreciated the equipment on a straight-line basis over a useful life of 10 years and used a residual value of $12,000. Chapmans depreciation expense for 2019 was $11,000. What was the original cost of the building? a. $98,000 b. $110,000 c. $122,000 d. $134,000On December 31, 2019, Vail Company owned the following assets: Vail computes depreciation and amortization expense to the nearest whole year. During 2020, Vail engaged in the following transactions: Required: 1. Check the accuracy of the accumulated depreciation balances at December 31, 2019. Round to the nearest whole dollar in all requirements. 2. Prepare journal entries to record the preceding events in 2020, as well as the year-end recording of depreciation expense. 3. Prepare an Accumulated Depreciation account for each category of assets, enter the beginning balance, post the journal entries from Requirement 2, and compute the ending balance.
- Balance Sheet and Notes Listed here in random order are Wicks Construction Limiteds balance sheet accounts and related ending balances as of December 31, 2019: Additional information: 1. The company reports on the balance sheet the total amount for inventories and the net book value of property, plant, and equipment, with the related details for each account disclosed in notes. 2. The straight line method is used to depreciate buildings, machinery, and equipment, based upon their cost and estimated residual values and lives. A breakdown of property, plant, and equipment shows the following: land at a cost of 32,000, buildings at a cost of 182,400 and a net book value of 120,200, machinery at a cost of 63,900, and related accumulated depreciation of 18,600, and equipment (40% depreciated) at a cost of 53,000. 3. Patents are amortized on a straight line basis directly to the Patent account. 4. Inventories are listed at the lower of cost or market value using an average cost. The inventories include raw-materials, 22,200; work in process, 34,700; and finished goods, 41,600. 5. Common stock has a 10 par value per share, 12,000 shares are authorized, and 6,280 shares have been issued. 6. Preferred stock has a 100 par value per share, 1,000 shares are authorized, and 400 shares have been issued. 7. The investment in bonds is carried at the original cost, which is the face value, and is being held to maturity. 8. Short-term investments in marketable securities were purchased at year-end. 9. The bonds payable mature on December 31, 2024. 10. The company attaches a 1-year warranty on all the products it sells. Required: 1. Prepare Wicks Constructions December 31, 2019, balance sheet (including appropriate parenthetical notations). 2. Prepare notes to accompany the balance sheet that itemize company accounting policies; inventories; and property, plant, and equipment. 3. Next Level Compute the current ratio and the quick ratio. How do these two ratios provide different information about the companys liquidity? Why are these ratios useful?Cost of Asset and Depreciation Method Heist Company purchased a machine on January 2, 2019, and uses the 150%-declining-balance depreciation method. The machine has an expected life of 10 years and an expected residual value of 5,000. The following costs relate to the acquisition and use of the machine during the first year of its operations: Required: 1. Compute the depreciation expense for 2019 and 2020. 2. Next Level What is the effect on the financial statements if the company used the straight-line method instead of the 150%-declining-balance method?Dinnell Company owns the following assets: In the year of acquisition and retirement of an asset, Dinnell records depreciation expense for one-half year. During 2020, Asset A was sold for 7,000. Required: Prepare the journal entries to record depreciation on each asset for 2017 through 2020 and the sale of Asset A. Round all answers to the nearest dollar.
- Depreciation Methods Nickle Company purchased three identical assets for 17,000 on January 2, 2019. Each asset has an expected residual value of 1,000. The depreciation expense for 2019 and 2020 is shown below for three assets: Required: 1. Next Level Which depreciation method is the company using for each asset? 2. Compute the depreciation expense for 2021 and 2022 for each asset.Depreciation Methods Sorter Company purchased equipment for 200,000 on January 2, 2019. The equipment has an estimated service life of 8 years and an estimated residual value of 20,000. Required: Compute the depreciation expense for 2019 under each of the following methods: 1. straight-line 2. sum-of-the-years-digits 3. double-declining-balance 4. Next Level What effect does the depreciation of the equipment have on the analysis of rate of return?On January 1, 2014, Klinefelter Company purchased a building for 520,000. The building had an estimated life of 20 years and an estimated residual value of 20,000. The company has been depreciating the building using straight-line depreciation. At the beginning of 2020, the following independent situations occur: a. The company estimates that the building has a remaining life of 10 years (for a total of 16 years). b. The company changes to the sum-of-the-years-digits method. c. The company discovers that it had ignored the estimated residual value in the computation of the annual depreciation each year. Required: For each of the independent situations, prepare all journal entries related to the building for 2020. Ignore income taxes.