Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I Need the LAST 2 formulas You can afford a monthly payment of $5,000. Using Goal Seek, what is the largest amount you can borrow

image text in transcribed

I Need the LAST 2 formulas

You can afford a monthly payment of $5,000. Using Goal Seek, what is the largest amount you can borrow keeping Number of Months and Annual Rate the same? 5 Points Amt Borrowed Number of Months Annual Interest Rate Monthly Payment $ 650,000.00 180 6% $5,485 (Use a negative sign to make the payment a positive value.) You want to keep your monthly payments at $4,000. Using Goal Seek, how much down payment do you need to make, keeping Purchase Price, Number of Months and Annual Rate the same? 10 Points Purchase Price Down Payment Amt Borrowed Number of Months Annual Interest Rate Monthly Payment $ 800,000.00 $ 120,000.00 $ 680,000.00 360 8% $4,990 (Use a negative sign to make the payment a positive value.) Your company needs a Gross Operating Profit of $650,000 in order to cover all Overhead and Fixed expenses. Using Goal Seek, how many units must you sell (leave the price per unit and cost per unit| unchanged)? 15 Points Price per Unit Units Sold Total Revenue $5.49 225,000 $280,172.41 $3.17 Cost per Unit Total COGS Gross Operating Profit

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Internal Auditing Handbook

Authors: K. H. Spencer Pickett

2nd Edition

0470848634, 978-0470848630

More Books

Students also viewed these Accounting questions