29. Explain how to prepare Depreciation Schedule and Loan
repayment schedule in data base management system
Answers
Answer:
To begin with, create the structure for the depreciation schedule as follows. The first line item to be referenced should be sales revenue. This is because sales revenue is a common driver for both capital expenditures and depreciation expense.
Below this, prepare a section for capital expenditures and reference historical CapEx from any available periods. Project future capital expenditures by using an appropriate forecasting assumption. Apply intuition to determine the proper forecasting assumption to use from the following:
CapEx as a percentage of sales
Fixed recurring amount
Reasonable “hard dollars” that one would expect a company to incur as they operate
Answer:
They can be of various forms: a daily sales report format will track sales KPIs that are relevant on a daily basis: the number of phone calls or meetings set up by a rep, or the number of leads created. Typically, weekly sales reports templates can monitor the number of deals closed by the team or the revenue generated. A monthly sales report format will provide a bigger picture of the activity of each sales rep or the team as a whole. Putting it all together on sales dashboards will enable you to automate your data and focus on human-centric tasks, without the need for time-consuming manual calculations and repetitive exports.