You are a CFA (chartered financial analyst). An overextended client has come to you because she needs help paying off her credit card bills. She owes the amounts on her credit cards listed in the file S14_98.xlsx. The client is willing to allocate up to $5000 per month to pay off these credit cards. All cards must be paid off within 36 months. The client’s goal is to minimize the total of all her payments. To solve this problem, you must understand how interest on a loan works. To illustrate, suppose the client pays $5000 on Saks during month 1. Then her Saks balance at the beginning of month 2 is 20,000 - [5000 - 0.005(20,000)]. This follows because she incurs 0.005(20,000) in interest charges on her Saks card during month 1. Help the client solve her problem. Once you have solved this problem, give an intuitive explanation of the solution found by Solver.
Answer to relevant QuestionsA food company produces two types of turkey cutlets for sale to fast-food restaurants. Each type of cutlet consists of white meat and dark meat. Cutlet 1 sells for $4 per pound and must consist of at least 70% white meat. ...It is currently the beginning of 2010. A city (labeled C for convenience) is trying to sell municipal bonds to support improvements in recreational facilities and highways. The face values (in thousands of dollars) of the ...Use @RISK to draw a triangular distribution with parameters 300, 500, and 900. Then answer the following questions.a. What are the mean and standard deviation of this distribution?b. What are the 5th and 95th percentiles of ...In the Walton Bookstore example, suppose that Walton receives no money for the first 50 excess calendars returned but receives $2.50 for every calendar after the first 50 returned. Does this change the optimal order quantity?The Fizzy Company produces six-packs of soda cans. Each can is supposed to contain at least 12 ounces of soda. If the total weight in a six-pack is less than 72 ounces, Fizzy is fined $100 and receives no sales revenue for ...
Post your question