Business project

Q&A for Final Project Business Plan 1) Question: We were originally given the spreadsheet with some yellow cells already filled in, when I replaced one of them I got the same value (611 for actuator demand), however I do not know if we should also replace the cell for our debt to semi. Should we recalculate this value or use the given one? You should replace these. A64 should be a formula as described in the comment. A71 will be a number that your group decides to price the actuator at. A122 will be the portion of assets that Semi is willing to fund; the corresponding percent is given in A21. 2) Question: In Cell A69, the hint next to it advises using "Goal Seek" to temporarily set A135=MARR by changing A67, however A67 and A135 are both text boxes and not cells with information. What cells should we be referencing instead? Answer: Sorry about the change in cells. This operation is done to figure out the minimum sell price that would just-pay-for the required capital. Use "Goal Seek" to vary cell A71 until A139 (ROA) is equal to A15 (the MARR). Enter the resulting value of A71 into A69. After you do this, put your proposed sell-price into A71. 3) Question: In general, I am assuming that all of the given values in the yellow cells needs to be replaced. Is this assumption correct?