The Colvilles are buying a new car. The cash price is $35,000.00. They will make a down payment of 20% or $5,000. The balance will be covered by an installment loan. The loan will be repaid in 48 monthly payments of $651. The annual percentage rate for the loan is %. (Round your answers to two decimal places.)

Conor is 21 years old and just started working after college. he has opened a retirement account that pays 2.5% interest compounded monthly. he plans on making monthly deposits of $200. how much will he have in the account when he reaches 591 years of age?

Wilson center is a private not-for-profit voluntary health and welfare entity. during 2017, it received unrestricted pledges of $638,000, 65 percent of which were payable in 2017, with the remainder payable in 2018 (for use in 2018). officials estimate that 14 percent of all pledges will be uncollectible. a. how much should wilson center report as contribution revenue for 2017? b. in addition, a local social worker, earning $20 per hour working for the state government, contributed 600 hours of time to wilson center at no charge. without these donated services, the organization would have hired an additional staff person. how should wilson center record the contributed service?

Dr. sperry, a biologist, is using excel to track growth rates of different populations of bacteria. she has a very complex formula in one cell. it begins with “round”. dr. sperry would like to see exactly how excel’s calculation reached the final rounded value that she sees in the cell. what could dr. sperry do to best understand how the calculation was made? try different formulas on her own until she reaches the value shown in excel click on the evaluate formula button in the formulas tab and then click “step in” select the cell and then look at the formula in the formula field of the ribbon remove “round” from the formula in order to see the actual value before rounding