Question

In: Accounting

Q. Separation of data and report areas (5 marks) Why should accounting spreadsheet reports be designed...

Q. Separation of data and report areas
Why should accounting spreadsheet reports be designed with a completely separate data entry area and a separate report area? Paste a simple spreadsheet example showing normal and formula views.

Solutions

Expert Solution

It is financial modelling best practice to keep your input data and reports in different tabs so that

  1. Mistakes in one file do not affect the other
  2. Ease of data entry updation and review-it is easier to understand a spreadsheet with clearly labelled input and output tabs
  3. Also when you have to add data for new reporting periods you can just modify one tab and update the report range.
  • All Excel formulas begin with an equal sign (=).
  • After the equal symbol, you enter either a calculation or function. For example, to add up values in cells B1 through B5, you can either:
    • Type the entire equation: =B1+B2+B3+B4+B5
    • Use the SUM function: =SUM(B1:B5)
  • Press the Enter key to complete the formula. Done!


Related Solutions

Q. Worksheet and financial reports (12 marks) Write a business report (about 600 words) critically evaluating...
Q. Worksheet and financial reports Write a business report (about 600 words) critically evaluating spreadsheets as a tool for accounting. Use Internet resources. Include a section on the advantages and disadvantages of spreadsheets. Refer to the Internet for advice on Business Report structures. Reference ALL your sources.
Issue: “Should there be a wall of separation between church and state?” Q: Issue: “Should there be...
Issue: “Should there be a wall of separation between church and state?” Q: Issue: “Should there be a wall of separation between church and state?”  Let's see what the class can do with this.   Seek and discuss some articles online
5 The top-left section of the spreadsheet is designed for summary statistics for one condition. You...
5 The top-left section of the spreadsheet is designed for summary statistics for one condition. You will calculate average selling prices and the number of houses sold in each city (the condition). In cell B2, insert the AVERAGEIF function to calculate the average Sold Price for houses in the city of Alpine. Use mixed references for the range; use a relative reference to cell A2. Copy the function and use the Paste Formulas option to paste the function in the...
A company reports accounting data in its financial statements.
1. Ratio analysis A company reports accounting data in its financial statements. This data is used for financial analyses that provide insights into a company's strengths, weaknesses, performance in speific areas, and trends in performance. These analyses are often used to compare a company's romance to that of its competitors, or to its past or expected future performance. Such insight helps managers and analysts improve their decision making. Your boss asked you to analyze Green Hamster Manufacturing's performance for the past three...
A company reports accounting data in its financial statements. This data is used for financial analyses that provide insights into a company’s strengths, weaknesses, performance in specific areas, and trends in performance.
A company reports accounting data in its financial statements. This data is used for financial analyses that provide insights into a company’s strengths, weaknesses, performance in specific areas, and trends in performance. These analyses are often used to compare a company’s performance to that of its competitors or to its past or expected future performance. Such insight helps managers and analysts improve their decision making.Consider the following scenario:You work as an analyst at a credit-rating agency, and you are comparing...
Students should define the areas of financial and managerial accounting as well as identify the differences...
Students should define the areas of financial and managerial accounting as well as identify the differences between the two areas of accounting. The paper should address the following differences between the two areas of accounting: What is the emphasis of each accounting area and why (i.e. historical data, future)? Describe the types of reports found in each area. What are the certifications an accountant can obtain in the areas? What are the current trends in managerial accounting? Provide references.
Why must accounting report be prepared according to specific procedures (GAAP)? Should we allow businesses some...
Why must accounting report be prepared according to specific procedures (GAAP)? Should we allow businesses some flexibility or creativity in preparing financial statements.
Task 8 - Hamming & SECDED Code (5+20= 25 marks) (a) (5 marks) For data, using...
Task 8 - Hamming & SECDED Code (5+20= 25 marks) (a) For data, using 3 Hamming code parity bits determine the maximum number of data bits that can be protected. (b) A SECDED encoded character has been retrieved, with the hexadecimal value of 409 to power of 16. You may assume that the SECDED parity is even. 1. (1 + 4 marks) Was there an error in transmission? Explain your answer. 2. If there was an error, either correct it...
What IT controls should prevent/detect the following threats? Explain (5 marks) 1. The data entry clerk...
What IT controls should prevent/detect the following threats? Explain 1. The data entry clerk mis-keys the customer number for a customer order, so the goods are sent to the wrong address and charged to the wrong customer. 2.An accounts payable clerk changes the bank details for a vendor to her own, enters a duplicate vendor invoice, and pays the amount to herself. 3.The sales system generates shipping documents as authority for shipment to customers, but some shipments are not invoiced...
The process of reviewing the recording procedures for an accounting information system should include three areas....
The process of reviewing the recording procedures for an accounting information system should include three areas. What are they
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT