Now we need to begin working on the worksheet 2. let's begin by renaming sheet 2 to loan data.
use the vlookup function to determine the interest rate & pmt function to determine the monthly payment.
column e: interest rate using vlookup
column f: down payment = vlookup to determine % required for down payment * selling price
column g: amount financed = selling price - down payment
column h: monthly payment = pmt function (monthly payment is at the beginning of each period)
cells c41 - c44: use functions count, min, max & sum to complete these loan statistics
picture of what the chart would be right here
format the data on this sheet for currency, percent, and so forth.
format the title rows and center them across the column selection. format the column headings appropriately.
format the loan term data and loan statistics with a clean outside border, color formatting, currency, and percent.
an example of what your loan data worksheet might look like is below.
this is where an example picture of it would be. it would be colored with green.

If you miss two payments on a credit card what is generally the penalty

Zachary company produces commercial gardening equipment. since production is highly automated, the company allocates its overhead costs to product lines using activity-based costing. the costs and cost drivers associated with the four overhead activity cost pools follow: activities unit level batch level product level facility level cost $ 64,800 $ 27,730 $ 15,000 $ 154,000 cost driver 2,400 labor hrs. 47 setups percentage of use 11,000 units production of 780 sets of cutting shears, one of the company’s 20 products, took 240 labor hours and 7 setups and consumed 15 percent of the product-sustaining activities. required: (a) had the company used labor hours as a company wide allocation base, how much overhead would it have allocated to the cutting shears? (b) how much overhead is allocated to the cutting shears using activity-based costing? (c) compute the overhead cost per unit for cutting shears first using activity-based costing and then using direct labor hours for allocation if 780 units are produced. if direct product costs are $150 and the product is priced at 30 percent above cost for what price would the product sell under each allocation system? (d) assuming that activity-based costing provides a more accurate estimate of cost, indicate whether the cutting shears would be over- or underpriced if direct labor hours are used as an allocation base. explain how over-or undercosting can affect vaulker's profitability. (e) comment on the validity of using the allocated facility-level cost in the pricing decision. should other costs be considered in a cost- plus pricing decision? if so, which ones? what costs would you include if you were trying to decide whether to accept a special order?

Two products, qi and vh, emerge from a joint process. product qi has been allocated $34,300 of the total joint costs of $55,000. a total of 2,900 units of product qi are produced from the joint process. product qi can be sold at the split-off point for $11 per unit, or it can be processed further for an additional total cost of $10,900 and then sold for $13 per unit. if product qi is processed further and sold, what would be the financial advantage (disadvantage) for the company compared with sale in its unprocessed form directly after the split-off point?