SENSITIVITY ANALYSIS with Data Table in Excel | ExcelJunction.com

Поделиться
HTML-код
  • Опубликовано: 15 янв 2025

Комментарии • 8

  • @strongestccp
    @strongestccp 10 месяцев назад

    This is great - thank you!

  • @annewangalachi3564
    @annewangalachi3564 3 года назад +1

    Very useful tips! Thank you.

  • @ayorindeandero7481
    @ayorindeandero7481 5 месяцев назад

    Very helpful! Thank you.

  • @chanthyum6825
    @chanthyum6825 6 месяцев назад

    good presentation, I understood from this very clearly. Thanks

  • @edcsallam
    @edcsallam 3 года назад +1

    Thanks

  • @khushisharma9540
    @khushisharma9540 2 года назад +1

    1. You’ve been assigned to analyze the profitability of Bill Clinton’s autobiography. The following assumptions have been made:
    • Bill is receiving a one-time royalty payment of $12 million.
    • The fixed cost of producing the hardcover version of the book is $1 million.
    • The variable cost of producing each hardcover book is $4.
    • The publisher’s net from book sales per hardcover unit sold is $15.
    • The publisher expects to sell 1 million hardcover copies.
    • The fixed cost of producing the paperback is $100,000.
    • The variable cost of producing each paperback book is $1.
    • The publisher’s net from book sales per paperback unit sold is $4.
    • Paperback sales will be double hardcover sales.
    Use this information to answer the following questions.

    a. Determine how the publisher’s before-tax profit will vary as hardcover sales vary from
    100,000 through 1 million copies.
    b. Determine how the publisher’s before-tax profit varies as hardcover sales vary from
    100,000 through 1 million copies and the ratio of paperback to hardcover sales varies
    from 1 through 2.4.
    Can you please solve this question

    • @Exceljunction
      @Exceljunction  Год назад

      Please join our WhatsApp / Telegram group and post your query there for quick resolution; links below:
      WhatsApp Group: www.exceljunction.com/whatsapp-group/
      Telegram Group: www.exceljunction.com/telegram-group/