Complete the growth estimates for the years 2022 to 2025 as follows:
a. In cell C16, create a formula that adds 1 to the growth rate (cell C14) and multiplies the result by the estimated profit from 2021 (cell C15).
b. Use an absolute row reference to cell C14.
c. Copy the formula from cell C16 to the range C17:C19 to enter the first estimates for 2023-2025.
d. Copy the formulas from the range C16:C19 to the range D16:119 to enter the remaining sales projections.
Answers: 2
Other questions on the subject: Business
Business, 21.06.2019 21:10, BABA3724
Auniversity spent $1.8 million to install solar panels atop a parking garage. these panels will have a capacity of 400 kilowatts (kw) and have a life expectancy of 20 years. suppose that the discount rate is 20%, that electricity can be purchased at $0.10 per kilowatt-hour (kwh), and that the marginal cost of electricity production using the solar panels is zero. hint: it may be easier to think of the present value of operating the solar panels for 1 hour per year first. approximately how many hours per year will the solar panels need to operate to enable this project to break even? a. a.3,696.48 b.14,785.92 c.9,241.20 if the solar panels can operate only for 8,317 hours a year at maximum, the project (would/would not)break even?
Answers: 1
Business, 22.06.2019 03:00, rafa3997
Fanning books buys books and magazines directly from publishers and distributes them to grocery stores. the wholesaler expects to purchase the following inventory: april may june required purchases (on account) $ 111,000 $ 131,000 $ 143,000 fanning books accountant prepared the following schedule of cash payments for inventory purchases. fanning books suppliers require that 85 percent of purchases on account be paid in the month of purchase; the remaining 15 percent are paid in the month following the month of purchase. required complete the schedule of cash payments for inventory purchases by filling in the missing amounts. determine the amount of accounts payable the company will report on its pro forma balance sheet at the end of the second quarter.
Answers: 2
Business, 22.06.2019 19:40, cieloromero1
Moody corporation uses a job-order costing system with a plantwide predetermined overhead rate based on machine-hours. at the beginning of the year, the company made the following estimates: machine-hours required to support estimated production 100,000 fixed manufacturing overhead cost $ 650,000 variable manufacturing overhead cost per machine-hour $ 3.00 required: 1. compute the plantwide predetermined overhead rate. 2. during the year, job 400 was started and completed. the following information was available with respect to this job: direct materials $ 450 direct labor cost $ 210 machine-hours used 40
Answers: 3
You know the right answer?
Complete the growth estimates for the years 2022 to 2025 as follows:
a. In cell C16, create a formu...
Questions in other subjects:
Mathematics, 18.03.2021 02:30
Mathematics, 18.03.2021 02:30
English, 18.03.2021 02:30
