Now suppose Elijah offers a discount on subsequent rooms for each house, such that he charges $40 for his frist room, $35 for his second, and $25 for each room thereafter. Assume 30% of his clients have only one room cleaned, 25% have two rooms cleaned, 30% have three rooms cleaned, and the remaining 15% have four rooms cleaned. How many houses will he have to clean before breaking even? If taxes are 25% of profits, how many rooms will he have to clean before making $15,000 profit? Answer the question by making a CVP worksheet similar to the depreciation sheets. Make sure it works well, uses cell references and functions/formulas when appropriate, and looks nice.

Now suppose Elijah offers a discount on subsequent rooms for each house, such that he charges $40 for his frist room, $35 for his second, and $25 for each room thereafter. Assume 30% of his clients have only one room cleaned, 25% have two rooms cleaned, 30% have three rooms cleaned, and the remaining 15% have four rooms cleaned. How many houses will he have to clean before breaking even? If taxes are 25% of profits, how many rooms will he have to clean before making $15,000 profit? Answer the question by making a CVP worksheet similar to the depreciation sheets. Make sure it works well, uses cell references and functions/formulas when appropriate, and looks nice.

Pfin (with Mindtap, 1 Term Printed Access Card) (mindtap Course List)

7th Edition

ISBN:9780357033609

Author:Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk

Publisher:Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk

Chapter13: Investing In Mutual Funds, Etfs, And Real Estate

Section: Chapter Questions

Problem 9FPE

See similar textbooks

Similar questions

You currently pay $10,000 per year in rent to a landlord for a $100,000 house, which you are considering purchasing. You can qualify for a loan of $80,000 at 9% if you put $20,000 down on the house. To raise money for the down payment, you would have to liquidate stock earning a 15% return. Neglect other concerns, like closing costs, capital gains, and tax consequences of owning, and determine whether it is better to rent or own.
Anita and Jim are considering a home equity loan to build a nice deck and patio in their back yard. They want to borrow $35,000 and are quoted an APR of 10%. If their marginal tax bracket is 24%, how much money can they save in taxes each year if capitalize on the tax-deductibility of interest paid on the home equity loan?
1.Link wants to make $100,000 after tax on his new venture into selling pizza-on-a-stick, using a "push along" cart at the beach. For each pizza-on-a-stick, he incurs raw material costs of $5 and sells them for $10. He pays a salary to his friend Zelda, who operates the cart for $50,000. If he buys the cart himself, he will incur fixed expenses of $20,000. Or, he can rent the cart and pay $1 to the cart supplier each time he sells a pizza stick. What is his point of indifference? That is, at what volume of pizza sticks is he indifferent about renting or buying the cart? (Insert a number ONLY) 2. Like Link, Chrom sells pizza-on-a-stick at the beach. But Chrom also sells dogs-in-a-pocket, which are hot dogs you can carry with you that have enough preservatives to survive in your pocket for years. For each pizza-on-a-stick, Chrom incurs raw material costs of $5 and sells them for $10. He incurs material costs of $3 for the dogs and sells them for $5. He sells 3 times as many dogs as he…
The Jacksons want to buy a condo in Langley. This will be their first property. Their combined gross annual salary is $108,000. They estimate that the property taxes are $2,400/year, strata fees $200/month and heating costs average $50/month. Banks use the affordability rule: no more than 32% of gross monthly hosehold income can go tawards paying the mortgage, property taxes, heating costs and 50% of the condo fees. What is the maximum monthly mortgage payment they could afford? Your Answer: Answer
please help me
Your uncle Fred just purchased a new boat. He brags to you about the low 7.0% interest rate (APR, monthly compounding) he obtained from the dealer. The rate is even lower than the rate he could have obtained on his home equity loan (8.0% APR, monthly compounding). But if his tax rate is 25% and the interest on the home equity loan is tax deductible, which loan is truly cheaper? The after-tax cost on the home equity loan is ______%. (Round to two decimal places.) Which is the cheaper loan? (Select the best choice below.) A. Both loans are the same when we account for taxes. B. We cannot tell which loan is cheaper since we do not know the value of the principal amounts. C. The home equity loan is cheaper than the boat loan from the dealer when compared on an after-tax basis. D. The boat loan from the dealer is cheaper than the home equity loan when compared on an after-tax basis.
Your uncle Fred just purchased a new boat. He brags to you about the low 6.9% interest rate (APR, monthly compounding) he obtained from the dealer. The rate is even lower than the rate he could have obtained on his home equity loan (8.1% APR, monthly compounding). But if his tax rate is 28% and the interest on the home equity loan is tax deductible, which loan is truly cheaper?
The Potters want to buy a small cottage costing $120,000 with annual insurance and taxes of $740 and $2200, respectively. They have saved $15,000 for a down payment, and they can get a 6%, 25-year mortgage from a bank. They are qualified for a home loan as long as the total monthly payment does not exceed $1000. Are they qualified? What is the total monthly payment?
Suppose you are in the 25% marginal tax bracket and earn $15,000. Then a tax credit of $1500 will reduce your tax bill by how much?
Alex makes $80,000 per year and pays about 30% of his gross monthly income in federal and state taxes. He wants to rent an apartment and pay no more than 25% of his income for rent. what is the maximum rent he can afford per month?
To finance his purchase of his new car, Sean must make a 10% down payment and pay all taxes up front. If the car has a sales price of $25,000 and state sales tax rate of 7%, how much money must Sean pay for the car up front?
The Hentys are considering buying a house and are researching the potential costs. Their adjusted gross income is $130,500. The monthly mortgage payment for the house they want would be $1,400. The annual property taxes would be $10,400. The homeowner’s annual insurance premium is $975. Will the bank lend them the money to purchase the house? Use a threshold of 28% front end ratio of monthly housing expenses to monthly gross income. YES- (21.6%)